Importing Packages

In [32]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
%matplotlib inline
from matplotlib.pylab import rcParams
rcParams['figure.figsize']=12,8
import warnings
warnings.filterwarnings("ignore")
import seaborn as sns

from sklearn.preprocessing import MinMaxScaler,StandardScaler
from sklearn.preprocessing import PowerTransformer
from sklearn.preprocessing import MinMaxScaler,StandardScaler,MaxAbsScaler
from sklearn.preprocessing import RobustScaler
from sklearn.preprocessing import QuantileTransformer
from sklearn.preprocessing import FunctionTransformer
from statsmodels.tsa.arima_model import ARIMA
from sklearn.metrics import mean_squared_error
from sklearn.model_selection import train_test_split
import itertools

Importing Data & Removing Duplicate Rows

In [2]:
data=pd.read_excel('JOB WISE .xlsx')
data=data.dropna()
data
Out[2]:
Job_Title Company_Name Location Posted_Date Salary Experience Skill Sector Job
0 Rooms Controller Marriott Nagpur 2020-01-07 Not disclosed 2-5 yrs Supervisor, Hospitality, Reservation, Manager ... Hospitality and Event Management Accomodation Services
1 Key Account Manager- Strategic Alliances & Cor... Prodigy Recruitment Consulting (OPC) Pvt. Ltd Pune, Nagpur, Mumbai 2020-03-04 12,00,000 - 22,00,000 PA. 10-20 Yrs Develop a strong product propositionStrategy &... Business Consulting and Management Account Manager
2 Hiring For a Key Account Manager Innovinc Services Nagpur 2020-03-04 Not disclosed 4-9 Yrs Communication SkillsLead GenerationClient Rela... Business Consulting and Management Account Manager
3 Purchase Executive Signum Fire Protection India Pvt. Ltd. Nagpur 2019-12-27 INR 1,50,000 - 2,25,000 PA. 1-3 yrs procurement executive, purchase, market resear... Sales Account Manager
4 Account Manager E&I HILTI Ahmedabad, Jodhpur, Nagpur 2019-12-31 Not disclosed 3-7 yrs Direct sales, Cold calling, Customer Service R... Sales Account Manager
... ... ... ... ... ... ... ... ... ...
9322 Senior Lab Technician / Lab Technician- Nagpur American Institute Of Pathology & Laboratory S... Nagpur 2020-02-20 Not disclosed 3-7 Yrs ISOPreventive MaintenanceMedical RecordsNABLTe... Science and Pharmaceutical Medical Laboratory Technician
9323 Data Entry Back Office transtech tech type data management Nagpur, Maharashtra 2020-03-12 ?23,000 a month Nature of work : - Typing WORK (PDF TO MS WORD... Nature of work : - Typing WORK (PDF TO MS WORD... Retail Data Entry Operator
9324 Office Boy GoldLeaf Production House Nagpur, Maharashtra 2020-03-12 ?5,000 - ?7,000 a month 1 Casual, 1 Medical Leave per month.\n Salary:... 1 Casual, 1 Medical Leave per month.\n Salary:... Retail Skilled Worker
9325 IT Coordinator Muthoot Microfin Ltd. Nagpur 2020-03-18 1,75,000 - 2,25,000 PA. 0-2 Yrs software testingsoftware supportcoordination Information Technology Computer Support Specialist
9326 Marketing Manager Harrier Information Systems Pvt Ltd Nagpur, Mumbai 2020-03-27 Not disclosed 3-6 Yrs Marketing Manager Marketing, Advertising and PR Digital Marketer

8372 rows × 9 columns

In [3]:
df1=data[['Job_Title','Company_Name','Posted_Date','Sector','Job']]
df1=df1.drop_duplicates()

df1['Posted_Date']=pd.to_datetime(df1['Posted_Date'])
In [4]:
sector=df1.groupby('Sector')['Sector'].count()
job=df1.groupby('Job')['Job'].count()
job=job.sort_values(ascending=False)
job
Out[4]:
Job
Sales Manager                       618
Software/Application Developer      515
General and Operations manager      463
Sales Development Representative    403
Web Developer                       258
                                   ... 
Healthcare Administrator              1
Guest Relation Manager                1
Education Councellor                  1
Dermatologist                         1
ACtuary                               1
Name: Job, Length: 199, dtype: int64
In [5]:
sector
Out[5]:
Sector
Accounting Finance and Banking            1
Accounting, Finance and Banking         507
Agriculture                               2
Business Consulting and Management      961
Business Counsulting and Management       1
Energy and Utilities                      4
Engineering and Manufacturing           461
Healthcare                              185
Hospitality and Event Management         50
Information Technology                 1152
Information Technonlogy                   1
Law                                      33
Law Enforcement and Security              7
Leisure, Sports and Tourism              24
Marketing, Advertising and PR            87
Media and Internet                      160
Property and Consultation                76
Public Service and Administration        56
Recruitment and HR                      147
Retail                                  648
Sales                                  1353
Science and Pharmaceutical                3
Science and Pharmaceuticals             127
Social Care                               4
Teacher Training and Education          439
Transport And Logistics                   1
Transport and Logistics                 163
Name: Sector, dtype: int64

Replacing misspelled Sector names with correct one

In [6]:
df1['Sector'].replace(['Information Technology \n','Information Technonlogy'],'Information Technology',inplace=True)
df1['Sector'].replace(['Business, consulting and management','business, consulting and management','Business Counsulting and Management'],'Business Consulting and Management',inplace=True)
df1['Sector'].replace(['Marketing, Advertising, and PR','marketing, Advertising, and PR','Marketing, Advertising and PR','Marketing Advertising and PR'],'Marketing, Advertising and PR',inplace=True)
df1['Sector'].replace(['Accountancy, banking, and finance jobs','Finance','Accounting , Finance and Banking','Accounting Finance and Banking'],'Accounting, Finance and Banking',inplace=True)
df1['Sector'].replace(['Public service and Administration','Public services and Administration','public services and Administration'],'Public Service and Administration',inplace=True)
df1['Sector'].replace(['Science and Pharmaceuticals \n','Science and Pharmaceutical','Science and Pharmaceuticals'],'Science and Pharmaceuticals',inplace=True)
df1['Sector'].replace(['Leisure, Sports, and Tourism'],'Leisure, Sports and Tourism',inplace=True)
df1['Sector'].replace(['Transport and logistics','Trasport and Logistics','Transport And Logistics'],'Transport and Logistics',inplace=True)
df1['Sector'].replace(['Media and the Internet'],'Media and Internet',inplace=True)
df1['Sector'].replace(['Teacher, Training and Education'],'Teacher Training and Education',inplace=True)
df1['Sector'].replace(['Social care'],'Social Care',inplace=True)
df1['Sector'].replace(['Energy and utilities'],'Energy and Utilities',inplace=True)
df1['Sector'].replace(['Law enforcement and security'],'Law Enforcement and Security',inplace=True)
In [7]:
sector=df1.groupby('Sector')['Sector'].count()
sector.sort_values(ascending=False)
Out[7]:
Sector
Sales                                 1353
Information Technology                1153
Business Consulting and Management     962
Retail                                 648
Accounting, Finance and Banking        508
Engineering and Manufacturing          461
Teacher Training and Education         439
Healthcare                             185
Transport and Logistics                164
Media and Internet                     160
Recruitment and HR                     147
Science and Pharmaceuticals            130
Marketing, Advertising and PR           87
Property and Consultation               76
Public Service and Administration       56
Hospitality and Event Management        50
Law                                     33
Leisure, Sports and Tourism             24
Law Enforcement and Security             7
Energy and Utilities                     4
Social Care                              4
Agriculture                              2
Name: Sector, dtype: int64
In [8]:
sector.count()
Out[8]:
22

Sector-wise jobs

In [9]:
sec=sector.sort_values(ascending=False)
for i in sec.index:
    d=df1[df1['Sector']==i]
    job_sec=d.groupby('Job')['Job'].count()
    print(i.upper()+'\n')
    for j in job_sec.index:
        print(j.capitalize())
    print('\n__________________________\n')
SALES

Account manager
It industry sales
Individual representative
Inside sales
Manufacture's representative
Medical sales representative
Sales development  representative
Sales development executive
Sales development representaitve
Sales development representative
Sales director
Sales manager
Sales operations manager

__________________________

INFORMATION TECHNOLOGY

Cloud computing engineers
Computer network specialist
Computer support specialist
Data modeler
Database administrator
Information technology analysts
Information technology leadership
Internet assessor 
Research
Software/application developer
Software/hardware engineer
Web developer

__________________________

BUSINESS CONSULTING AND MANAGEMENT

Account manager
Accountant
Actuary
Auditor
Business teacher
Corporate attorney
Financial analyst
General and operations manager
Healthcare administrator
It consultant
Management consultant
Management counsultant
Management counsultant
Managenemt consultant
Marketing manager
Operations counsultant
Public relations
Receptionist
Sales manager
Secretary

__________________________

RETAIL

Back office executive
Cashier
Computer operator
Customer service representative
Data entry operator
Driver
Front office executive
Retail it coordinator
Sales
Sales associate
Sales job titles
Skilled worker
Skilled workers
Skilled workers
Welder/fitter

__________________________

ACCOUNTING, FINANCE AND BANKING

Actuary
Accountant
Accounting  clerk
Accounting clerk
Actuary
Auditor
Cfo
Commercial real estate agent
Controller
Credit analyst
Financial analyst
Investor  relation associate
Investor relation associate

__________________________

ENGINEERING AND MANUFACTURING

Biomedical enginner
Chemical engineer
Civil engineer
Civil engineering
Electrial engineer
Engineering techician
Engineering technician
Environmental engineer
Industrial enginner
Machinist/operator
Mechanical engineer
Production manager
Quality control inspector
Quality control inspector
Software/hardware engineer
Surveyor
Environmental engineer

__________________________

TEACHER TRAINING AND EDUCATION

Assistant professor
Associate professor
Centre head/director
Director
Education councellor
Education counsellor
Lab technician
Principal
Professor
Teacher
Trainer
Vice principal
Principal

__________________________

HEALTHCARE

Anesthetist
Associate professor
B.a.m.s
Clinical coder
Dental
Dermatologist
Dietician
Gynaecologist
Hospital administrator
Medical transcription
Medical writer
Neurologist
Nursing
Optometrists
Paediatrician
Physician
Physiotherapist
Psychologist
Radiologist
Resident medical officer
Support healthcare
Veterinarian

__________________________

TRANSPORT AND LOGISTICS

Air transportation worker
Air transportation workers
Distribution/ warehousing operations
Freight manager
Material mover
Sales manager
Sales operations manager
Traffic, transportation, and travel logistics

__________________________

MEDIA AND INTERNET

Content writer
Digital marketer
Graphic designer
Media executive
News editor
Photographer
Web content  manager
Web content manager
Web designer
Content writer

__________________________

RECRUITMENT AND HR

Hr consultant
Hr executive
Hr it specialist
Hr manager
Hr recruiter
Placement officer/coordinator
Recruitment

__________________________

SCIENCE AND PHARMACEUTICALS

Biomedical
Medical laboratory technician
Medical representative
Microbiologist
Nuclear medicine
Pathologist
Pharmacist
Pharmacologist
Physician

__________________________

MARKETING, ADVERTISING AND PR

Digital marketer
Marketing manager
Sales job titles

__________________________

PROPERTY AND CONSULTATION

Architect
Civil engineer
Draftsman
Interior designer
Property broker
Property manager
Safety officer
Supervisor
Surveyor

__________________________

PUBLIC SERVICE AND ADMINISTRATION

Clerk
Librarian
Public service assistant
Public service associates
Registrar
Safety officer
Safety services
Secretary

__________________________

HOSPITALITY AND EVENT MANAGEMENT

Accomodation services
Chef
Cook
Event manager
Event planner
Food and  beverage executive
Food and beverage executive
Front desk
Guest relation manager
Hospitality training
Hotel general manager
Housekeeper
Lead auditor
Maintainance manager
Maintainence worker
Receptionist
Sales and marketing executive
Scoopers
Security guard
Store manager
Waiter

__________________________

LAW

Advocate
Ipr officer
Ir officer
Lawyer
Legal marketing professional
Legal officer
Legislator
Liaison officer

__________________________

LEISURE, SPORTS AND TOURISM

Aviation jobs
Fitness trainer
Management
Marketing
Tour manager
Travel trainer

__________________________

LAW ENFORCEMENT AND SECURITY

Security guard
Security supervisor

__________________________

ENERGY AND UTILITIES

Mining engineer/officer
Solar site supervisor

__________________________

SOCIAL CARE

Warden

__________________________

AGRICULTURE

Quality control inspector
Quality control inspector

__________________________

Jobs that Appeared Frequently

In [10]:
job_date=pd.DataFrame(columns=['Job','Number of Sample'])
for i in job.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    job_samp=pd.DataFrame({"Job":[i],"Number of Sample":[d_it.count()]}, index=[0])
    job_date=job_date.append(job_samp,ignore_index=True)
job_data=job_date.sort_values(by='Number of Sample', ascending=False)
job_data=job_data[job_data['Number of Sample']>=35]
job_pre=job_data.set_index(['Job'])
job_pre
Out[10]:
Number of Sample
Job
Sales Manager 101
Software/Application Developer 93
Sales Development Representative 91
General and Operations manager 89
Customer Service Representative 80
Accountant 77
Sales Operations Manager 70
Management counsultant 69
Web Developer 69
Sales Director 58
Teacher 58
Skilled Workers 52
Data Entry Operator 50
Medical Representative 48
Trainer 46
Electrial Engineer 45
Graphic Designer 45
Data Modeler 43
Civil Engineer 43
Financial Analyst 43
Content Writer 43
Computer Network Specialist 43
Actuary 42
Investor Relation Associate 41
HR Executive 40
Sales Associate 40
Computer Support Specialist 38
Computer Operator 35
IT Industry Sales 35
Receptionist 35

Plotting Job-wise Time Series data

In [11]:
fig, ax1 = plt.subplots(len(job.index[0:20]),figsize=(24,50))
#sns.set(font_scale=1) 
plot=0

for i in job.index[0:20]:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    sns.set(font_scale=1) 
    ax1[plot].plot(d_it,label=i)  
    ax1[plot].legend()
    plot=plot+1  

Top 25 Jobs

In [12]:
fig_dims = (40, 30)
sns.set(font_scale=3) 
fig, ax = plt.subplots(figsize=fig_dims)
sns.barplot(x=job.values[0:25],y=job.index[0:25],ax=ax)
plt.ylabel('Jobs',fontweight='bold')
ax.set_title('Job Postings\n',fontweight='bold')
Out[12]:
Text(0.5, 1.0, 'Job Postings\n')

Checking Stationarity in time series

  • Determing rolling statistics
  • Perform Dickey-Fuller test
In [13]:
from statsmodels.tsa.stattools import adfuller
stat=pd.DataFrame(columns=['Transformation','Job','Test Statistic','p-value','Critical Value (1%)','Critical Value (5%)'])
def test_stationarity(timeseries,Transformation,job):
    sns.set(font_scale=1)
    #Determing rolling statistics
    rolmean=timeseries.rolling(window=10).mean()
    rolstd=timeseries.rolling(window=10).std()

    #Plot rolling statistics:
    orig = plt.plot(timeseries, color='blue',label='Original')
    mean = plt.plot(rolmean, color='red', label='Rolling Mean')
    std = plt.plot(rolstd, color='black', label = 'Rolling Std')
    plt.legend(loc='best')
    plt.title('Rolling Mean & Standard Deviation')
    plt.show(block=False)
    
    #Perform Dickey-Fuller test:
    print ('Results of Dickey-Fuller Test:')
    dftest = adfuller(timeseries, autolag='AIC')
    dfoutput = pd.Series(dftest[0:4], index=['Test Statistic','p-value','#Lags Used','Number of Observations Used'])
    for key,value in dftest[4].items():
        dfoutput['Critical Value (%s)'%key] = value
    print(dfoutput)
    d=dftest[4]
    #print(d['1%'])
    global stat
    trans_stat=pd.DataFrame({"Transformation":[Transformation],"Job":[job],"Test Statistic":[dftest[0]],"p-value":[dftest[1]],"Critical Value (1%)":d['1%'],"Critical Value (5%)":d['5%']}, index=[0])
    stat=stat.append(trans_stat,ignore_index=True)

DATA TRANSFORMATION

1. Log Transformation

In [14]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i.upper())
    demand_log=np.log(d_it)
    test_stationarity(d_it,'Log Transformation',i)
    print('\n------------------------------------------------------\n')
SALES MANAGER
Results of Dickey-Fuller Test:
Test Statistic                -8.064442e+00
p-value                        1.610355e-12
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

SOFTWARE/APPLICATION DEVELOPER
Results of Dickey-Fuller Test:
Test Statistic                -5.692333e+00
p-value                        8.017971e-07
#Lags Used                     0.000000e+00
Number of Observations Used    9.200000e+01
Critical Value (1%)           -3.503515e+00
Critical Value (5%)           -2.893508e+00
Critical Value (10%)          -2.583824e+00
dtype: float64

------------------------------------------------------

SALES DEVELOPMENT REPRESENTATIVE
Results of Dickey-Fuller Test:
Test Statistic                 -4.477390
p-value                         0.000216
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

GENERAL AND OPERATIONS MANAGER
Results of Dickey-Fuller Test:
Test Statistic                -7.248987e+00
p-value                        1.800750e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

CUSTOMER SERVICE REPRESENTATIVE
Results of Dickey-Fuller Test:
Test Statistic                -6.332940e+00
p-value                        2.876519e-08
#Lags Used                     0.000000e+00
Number of Observations Used    7.900000e+01
Critical Value (1%)           -3.515977e+00
Critical Value (5%)           -2.898886e+00
Critical Value (10%)          -2.586694e+00
dtype: float64

------------------------------------------------------

ACCOUNTANT
Results of Dickey-Fuller Test:
Test Statistic                -5.950297e+00
p-value                        2.155174e-07
#Lags Used                     0.000000e+00
Number of Observations Used    7.600000e+01
Critical Value (1%)           -3.519481e+00
Critical Value (5%)           -2.900395e+00
Critical Value (10%)          -2.587498e+00
dtype: float64

------------------------------------------------------

SALES OPERATIONS MANAGER
Results of Dickey-Fuller Test:
Test Statistic                -6.215294e+00
p-value                        5.384224e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

MANAGEMENT COUNSULTANT
Results of Dickey-Fuller Test:
Test Statistic                -5.721408e+00
p-value                        6.927615e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

WEB DEVELOPER
Results of Dickey-Fuller Test:
Test Statistic                 -5.096311
p-value                         0.000014
#Lags Used                      1.000000
Number of Observations Used    67.000000
Critical Value (1%)            -3.531955
Critical Value (5%)            -2.905755
Critical Value (10%)           -2.590357
dtype: float64

------------------------------------------------------

SALES DIRECTOR
Results of Dickey-Fuller Test:
Test Statistic                -5.902054e+00
p-value                        2.763263e-07
#Lags Used                     0.000000e+00
Number of Observations Used    5.700000e+01
Critical Value (1%)           -3.550670e+00
Critical Value (5%)           -2.913766e+00
Critical Value (10%)          -2.594624e+00
dtype: float64

------------------------------------------------------

TEACHER
Results of Dickey-Fuller Test:
Test Statistic                 -2.737167
p-value                         0.067825
#Lags Used                      5.000000
Number of Observations Used    52.000000
Critical Value (1%)            -3.562879
Critical Value (5%)            -2.918973
Critical Value (10%)           -2.597393
dtype: float64

------------------------------------------------------

SKILLED WORKERS
Results of Dickey-Fuller Test:
Test Statistic                -8.589371e+00
p-value                        7.357021e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

DATA ENTRY OPERATOR
Results of Dickey-Fuller Test:
Test Statistic                 -3.474673
p-value                         0.008662
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

MEDICAL REPRESENTATIVE
Results of Dickey-Fuller Test:
Test Statistic                 -3.272182
p-value                         0.016169
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

TRAINER
Results of Dickey-Fuller Test:
Test Statistic                 -2.124539
p-value                         0.234763
#Lags Used                      4.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

ELECTRIAL ENGINEER
Results of Dickey-Fuller Test:
Test Statistic                 -4.427601
p-value                         0.000265
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

GRAPHIC DESIGNER
Results of Dickey-Fuller Test:
Test Statistic                 -5.583107
p-value                         0.000001
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

DATA MODELER
Results of Dickey-Fuller Test:
Test Statistic                -6.510337e+00
p-value                        1.104471e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

CIVIL ENGINEER
Results of Dickey-Fuller Test:
Test Statistic                -6.638242e+00
p-value                        5.492855e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

FINANCIAL ANALYST
Results of Dickey-Fuller Test:
Test Statistic                 -4.886284
p-value                         0.000037
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

CONTENT WRITER
Results of Dickey-Fuller Test:
Test Statistic                -5.691809e+00
p-value                        8.039062e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

COMPUTER NETWORK SPECIALIST
Results of Dickey-Fuller Test:
Test Statistic                 -4.964913
p-value                         0.000026
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

ACTUARY
Results of Dickey-Fuller Test:
Test Statistic                -7.146346e+00
p-value                        3.225321e-10
#Lags Used                     0.000000e+00
Number of Observations Used    4.100000e+01
Critical Value (1%)           -3.600983e+00
Critical Value (5%)           -2.935135e+00
Critical Value (10%)          -2.605963e+00
dtype: float64

------------------------------------------------------

INVESTOR RELATION ASSOCIATE
Results of Dickey-Fuller Test:
Test Statistic                 -4.764090
p-value                         0.000064
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR EXECUTIVE
Results of Dickey-Fuller Test:
Test Statistic                -5.685763e+00
p-value                        8.286640e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

SALES ASSOCIATE
Results of Dickey-Fuller Test:
Test Statistic                -5.701978e+00
p-value                        7.638881e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

COMPUTER SUPPORT SPECIALIST
Results of Dickey-Fuller Test:
Test Statistic                 -4.579822
p-value                         0.000141
#Lags Used                      1.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

COMPUTER OPERATOR
Results of Dickey-Fuller Test:
Test Statistic                 -2.908719
p-value                         0.044343
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT INDUSTRY SALES
Results of Dickey-Fuller Test:
Test Statistic                 -4.423987
p-value                         0.000269
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

RECEPTIONIST
Results of Dickey-Fuller Test:
Test Statistic                  0.971853
p-value                         0.993960
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

2. MaxMinScaler Transfromation (Normalization)

In [15]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=MinMaxScaler(feature_range=(0,1))
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_nor=demand_nor.flatten()
    demand_nor=pd.Series(demand_nor,index=index)
    test_stationarity(demand_nor,'MaxMinScaler Transfromation (Normalization)',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -8.064442e+00
p-value                        1.610355e-12
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                -5.692333e+00
p-value                        8.017971e-07
#Lags Used                     0.000000e+00
Number of Observations Used    9.200000e+01
Critical Value (1%)           -3.503515e+00
Critical Value (5%)           -2.893508e+00
Critical Value (10%)          -2.583824e+00
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.477390
p-value                         0.000216
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.248987e+00
p-value                        1.800750e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                -6.332940e+00
p-value                        2.876519e-08
#Lags Used                     0.000000e+00
Number of Observations Used    7.900000e+01
Critical Value (1%)           -3.515977e+00
Critical Value (5%)           -2.898886e+00
Critical Value (10%)          -2.586694e+00
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                -5.950297e+00
p-value                        2.155174e-07
#Lags Used                     0.000000e+00
Number of Observations Used    7.600000e+01
Critical Value (1%)           -3.519481e+00
Critical Value (5%)           -2.900395e+00
Critical Value (10%)          -2.587498e+00
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.215294e+00
p-value                        5.384224e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -5.721408e+00
p-value                        6.927615e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -5.096311
p-value                         0.000014
#Lags Used                      1.000000
Number of Observations Used    67.000000
Critical Value (1%)            -3.531955
Critical Value (5%)            -2.905755
Critical Value (10%)           -2.590357
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                -5.902054e+00
p-value                        2.763263e-07
#Lags Used                     0.000000e+00
Number of Observations Used    5.700000e+01
Critical Value (1%)           -3.550670e+00
Critical Value (5%)           -2.913766e+00
Critical Value (10%)          -2.594624e+00
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -2.737167
p-value                         0.067825
#Lags Used                      5.000000
Number of Observations Used    52.000000
Critical Value (1%)            -3.562879
Critical Value (5%)            -2.918973
Critical Value (10%)           -2.597393
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.589371e+00
p-value                        7.357021e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.474673
p-value                         0.008662
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.272182
p-value                         0.016169
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -2.124539
p-value                         0.234763
#Lags Used                      4.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -4.427601
p-value                         0.000265
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.583107
p-value                         0.000001
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.510337e+00
p-value                        1.104471e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.638242e+00
p-value                        5.492855e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.886284
p-value                         0.000037
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.691809e+00
p-value                        8.039062e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.964913
p-value                         0.000026
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                -7.146346e+00
p-value                        3.225321e-10
#Lags Used                     0.000000e+00
Number of Observations Used    4.100000e+01
Critical Value (1%)           -3.600983e+00
Critical Value (5%)           -2.935135e+00
Critical Value (10%)          -2.605963e+00
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -4.764090
p-value                         0.000064
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                -5.685763e+00
p-value                        8.286640e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                -5.701978e+00
p-value                        7.638881e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.579822
p-value                         0.000141
#Lags Used                      1.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -2.908719
p-value                         0.044343
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.423987
p-value                         0.000269
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.971853
p-value                         0.993960
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

3. StandardScaler Transformation (Standardization)

In [16]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    
    demand_values=d_it.values
    demand_values=demand_values.reshape(len(demand_values),1)
    std_scaler=StandardScaler()
    std_scaler_fit=std_scaler.fit(demand_values)
    demand_std=std_scaler.transform(demand_values)
    index=d_it.index
    demand_std=demand_std.flatten()
    demand_std=pd.Series(demand_std,index=index)
    test_stationarity(demand_std,'StandardScaler Transformation (Standardization)',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -8.064442e+00
p-value                        1.610355e-12
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                -5.692333e+00
p-value                        8.017971e-07
#Lags Used                     0.000000e+00
Number of Observations Used    9.200000e+01
Critical Value (1%)           -3.503515e+00
Critical Value (5%)           -2.893508e+00
Critical Value (10%)          -2.583824e+00
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.477390
p-value                         0.000216
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.248987e+00
p-value                        1.800750e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                -6.332940e+00
p-value                        2.876519e-08
#Lags Used                     0.000000e+00
Number of Observations Used    7.900000e+01
Critical Value (1%)           -3.515977e+00
Critical Value (5%)           -2.898886e+00
Critical Value (10%)          -2.586694e+00
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                -5.950297e+00
p-value                        2.155174e-07
#Lags Used                     0.000000e+00
Number of Observations Used    7.600000e+01
Critical Value (1%)           -3.519481e+00
Critical Value (5%)           -2.900395e+00
Critical Value (10%)          -2.587498e+00
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.215294e+00
p-value                        5.384224e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -5.721408e+00
p-value                        6.927615e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -5.096311
p-value                         0.000014
#Lags Used                      1.000000
Number of Observations Used    67.000000
Critical Value (1%)            -3.531955
Critical Value (5%)            -2.905755
Critical Value (10%)           -2.590357
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                -5.902054e+00
p-value                        2.763263e-07
#Lags Used                     0.000000e+00
Number of Observations Used    5.700000e+01
Critical Value (1%)           -3.550670e+00
Critical Value (5%)           -2.913766e+00
Critical Value (10%)          -2.594624e+00
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -2.737167
p-value                         0.067825
#Lags Used                      5.000000
Number of Observations Used    52.000000
Critical Value (1%)            -3.562879
Critical Value (5%)            -2.918973
Critical Value (10%)           -2.597393
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.589371e+00
p-value                        7.357021e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.474673
p-value                         0.008662
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.272182
p-value                         0.016169
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -2.124539
p-value                         0.234763
#Lags Used                      4.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -4.427601
p-value                         0.000265
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.583107
p-value                         0.000001
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.510337e+00
p-value                        1.104471e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.638242e+00
p-value                        5.492855e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.886284
p-value                         0.000037
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.691809e+00
p-value                        8.039062e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.964913
p-value                         0.000026
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                -7.146346e+00
p-value                        3.225321e-10
#Lags Used                     0.000000e+00
Number of Observations Used    4.100000e+01
Critical Value (1%)           -3.600983e+00
Critical Value (5%)           -2.935135e+00
Critical Value (10%)          -2.605963e+00
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -4.764090
p-value                         0.000064
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                -5.685763e+00
p-value                        8.286640e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                -5.701978e+00
p-value                        7.638881e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.579822
p-value                         0.000141
#Lags Used                      1.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -2.908719
p-value                         0.044343
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.423987
p-value                         0.000269
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.971853
p-value                         0.993960
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

4. Square Root Transformation

In [17]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_sqrt=np.sqrt(d_it)
    test_stationarity(demand_sqrt,'Square Root Transformation',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -7.085510e+00
p-value                        4.549511e-10
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                 -5.614652
p-value                         0.000001
#Lags Used                      0.000000
Number of Observations Used    92.000000
Critical Value (1%)            -3.503515
Critical Value (5%)            -2.893508
Critical Value (10%)           -2.583824
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.540434
p-value                         0.000166
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.134434e+00
p-value                        3.450343e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.234303
p-value                         0.000576
#Lags Used                      1.000000
Number of Observations Used    78.000000
Critical Value (1%)            -3.517114
Critical Value (5%)            -2.899375
Critical Value (10%)           -2.586955
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                -5.739210e+00
p-value                        6.332992e-07
#Lags Used                     0.000000e+00
Number of Observations Used    7.600000e+01
Critical Value (1%)           -3.519481e+00
Critical Value (5%)           -2.900395e+00
Critical Value (10%)          -2.587498e+00
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.197563e+00
p-value                        5.914330e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -5.664310e+00
p-value                        9.226624e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -3.418524
p-value                         0.010343
#Lags Used                      2.000000
Number of Observations Used    66.000000
Critical Value (1%)            -3.533560
Critical Value (5%)            -2.906444
Critical Value (10%)           -2.590724
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                 -5.642245
p-value                         0.000001
#Lags Used                      0.000000
Number of Observations Used    57.000000
Critical Value (1%)            -3.550670
Critical Value (5%)            -2.913766
Critical Value (10%)           -2.594624
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -2.682353
p-value                         0.077142
#Lags Used                      5.000000
Number of Observations Used    52.000000
Critical Value (1%)            -3.562879
Critical Value (5%)            -2.918973
Critical Value (10%)           -2.597393
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.607466e+00
p-value                        6.612670e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.441702
p-value                         0.009617
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.310187
p-value                         0.014429
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -1.968158
p-value                         0.300707
#Lags Used                      4.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -4.778418
p-value                         0.000060
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.527031
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.556504e+00
p-value                        8.590088e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.800582e+00
p-value                        2.242454e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.613515
p-value                         0.000122
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.762301e+00
p-value                        5.635531e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -5.131126
p-value                         0.000012
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                -7.279600e+00
p-value                        1.512554e-10
#Lags Used                     0.000000e+00
Number of Observations Used    4.100000e+01
Critical Value (1%)           -3.600983e+00
Critical Value (5%)           -2.935135e+00
Critical Value (10%)          -2.605963e+00
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -5.187650
p-value                         0.000009
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -5.399680
p-value                         0.000003
#Lags Used                      0.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                 -3.513653
p-value                         0.007643
#Lags Used                      7.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.565507
p-value                         0.000149
#Lags Used                      1.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -2.869859
p-value                         0.048967
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.482828
p-value                         0.000211
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.956349
p-value                         0.993783
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

5. Cube Root Transfromation

In [18]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_cbrt=np.cbrt(d_it)
    test_stationarity(demand_cbrt,'Cube Root Transformation',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.827396e+00
p-value                        1.932181e-09
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                -5.690849e+00
p-value                        8.077892e-07
#Lags Used                     0.000000e+00
Number of Observations Used    9.200000e+01
Critical Value (1%)           -3.503515e+00
Critical Value (5%)           -2.893508e+00
Critical Value (10%)          -2.583824e+00
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.596642
p-value                         0.000131
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.174184e+00
p-value                        2.754563e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.195792
p-value                         0.000670
#Lags Used                      1.000000
Number of Observations Used    78.000000
Critical Value (1%)            -3.517114
Critical Value (5%)            -2.899375
Critical Value (10%)           -2.586955
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                -5.700479e+00
p-value                        7.696632e-07
#Lags Used                     0.000000e+00
Number of Observations Used    7.600000e+01
Critical Value (1%)           -3.519481e+00
Critical Value (5%)           -2.900395e+00
Critical Value (10%)          -2.587498e+00
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.177249e+00
p-value                        6.584914e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -5.677136e+00
p-value                        8.652830e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -3.380071
p-value                         0.011657
#Lags Used                      2.000000
Number of Observations Used    66.000000
Critical Value (1%)            -3.533560
Critical Value (5%)            -2.906444
Critical Value (10%)           -2.590724
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                 -5.568754
p-value                         0.000001
#Lags Used                      0.000000
Number of Observations Used    57.000000
Critical Value (1%)            -3.550670
Critical Value (5%)            -2.913766
Critical Value (10%)           -2.594624
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -2.693467
p-value                         0.075176
#Lags Used                      5.000000
Number of Observations Used    52.000000
Critical Value (1%)            -3.562879
Critical Value (5%)            -2.918973
Critical Value (10%)           -2.597393
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.596034e+00
p-value                        7.073671e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.411955
p-value                         0.010558
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.326546
p-value                         0.013733
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -1.920184
p-value                         0.322626
#Lags Used                      4.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -4.934489
p-value                         0.000030
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.513417
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.590416e+00
p-value                        7.137887e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.840555e+00
p-value                        1.795833e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.530668
p-value                         0.000173
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.781898e+00
p-value                        5.102970e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -5.204117
p-value                         0.000009
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                -7.293223e+00
p-value                        1.399485e-10
#Lags Used                     0.000000e+00
Number of Observations Used    4.100000e+01
Critical Value (1%)           -3.600983e+00
Critical Value (5%)           -2.935135e+00
Critical Value (10%)          -2.605963e+00
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -5.318051
p-value                         0.000005
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -5.307842
p-value                         0.000005
#Lags Used                      0.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                 -3.533594
p-value                         0.007165
#Lags Used                      7.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.722232
p-value                         0.000076
#Lags Used                      0.000000
Number of Observations Used    37.000000
Critical Value (1%)            -3.620918
Critical Value (5%)            -2.943539
Critical Value (10%)           -2.610400
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -2.858123
p-value                         0.050439
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.503666
p-value                         0.000194
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.941910
p-value                         0.993614
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

6. Differencing Transformation (Shift 1)

In [19]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_diff=d_it.diff(periods=1)
    demand_diff.dropna(inplace=True)
    test_stationarity(demand_diff,'Differencing Transformation (Shift 1)',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -8.297155e+00
p-value                        4.110608e-13
#Lags Used                     4.000000e+00
Number of Observations Used    9.500000e+01
Critical Value (1%)           -3.501137e+00
Critical Value (5%)           -2.892480e+00
Critical Value (10%)          -2.583275e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                -6.451391e+00
p-value                        1.520391e-08
#Lags Used                     8.000000e+00
Number of Observations Used    8.300000e+01
Critical Value (1%)           -3.511712e+00
Critical Value (5%)           -2.897048e+00
Critical Value (10%)          -2.585713e+00
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                -5.835601e+00
p-value                        3.883228e-07
#Lags Used                     7.000000e+00
Number of Observations Used    8.200000e+01
Critical Value (1%)           -3.512738e+00
Critical Value (5%)           -2.897490e+00
Critical Value (10%)          -2.585949e+00
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -1.022456e+01
p-value                        5.217994e-18
#Lags Used                     1.000000e+00
Number of Observations Used    8.600000e+01
Critical Value (1%)           -3.508783e+00
Critical Value (5%)           -2.895784e+00
Critical Value (10%)          -2.585038e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                -6.597223e+00
p-value                        6.877043e-09
#Lags Used                     3.000000e+00
Number of Observations Used    7.500000e+01
Critical Value (1%)           -3.520713e+00
Critical Value (5%)           -2.900925e+00
Critical Value (10%)          -2.587781e+00
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                -7.729892e+00
p-value                        1.132750e-11
#Lags Used                     2.000000e+00
Number of Observations Used    7.300000e+01
Critical Value (1%)           -3.523284e+00
Critical Value (5%)           -2.902031e+00
Critical Value (10%)          -2.588371e+00
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.354349e+00
p-value                        2.564607e-08
#Lags Used                     5.000000e+00
Number of Observations Used    6.300000e+01
Critical Value (1%)           -3.538695e+00
Critical Value (5%)           -2.908645e+00
Critical Value (10%)          -2.591897e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -7.324856e+00
p-value                        1.168250e-10
#Lags Used                     4.000000e+00
Number of Observations Used    6.300000e+01
Critical Value (1%)           -3.538695e+00
Critical Value (5%)           -2.908645e+00
Critical Value (10%)          -2.591897e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -5.514296
p-value                         0.000002
#Lags Used                      6.000000
Number of Observations Used    61.000000
Critical Value (1%)            -3.542413
Critical Value (5%)            -2.910236
Critical Value (10%)           -2.592745
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                -6.691007e+00
p-value                        4.109797e-09
#Lags Used                     3.000000e+00
Number of Observations Used    5.300000e+01
Critical Value (1%)           -3.560242e+00
Critical Value (5%)           -2.917850e+00
Critical Value (10%)          -2.596796e+00
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                -6.934719e+00
p-value                        1.061871e-09
#Lags Used                     4.000000e+00
Number of Observations Used    5.200000e+01
Critical Value (1%)           -3.562879e+00
Critical Value (5%)           -2.918973e+00
Critical Value (10%)          -2.597393e+00
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -5.919913e+00
p-value                        2.520737e-07
#Lags Used                     3.000000e+00
Number of Observations Used    4.700000e+01
Critical Value (1%)           -3.577848e+00
Critical Value (5%)           -2.925338e+00
Critical Value (10%)          -2.600774e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -5.595634
p-value                         0.000001
#Lags Used                      5.000000
Number of Observations Used    43.000000
Critical Value (1%)            -3.592504
Critical Value (5%)            -2.931550
Critical Value (10%)           -2.604066
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                -1.469741e+01
p-value                        2.983303e-27
#Lags Used                     0.000000e+00
Number of Observations Used    4.600000e+01
Critical Value (1%)           -3.581258e+00
Critical Value (5%)           -2.926785e+00
Critical Value (10%)          -2.601541e+00
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -5.275751
p-value                         0.000006
#Lags Used                      3.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                -8.333291e+00
p-value                        3.323749e-13
#Lags Used                     0.000000e+00
Number of Observations Used    4.300000e+01
Critical Value (1%)           -3.592504e+00
Critical Value (5%)           -2.931550e+00
Critical Value (10%)          -2.604066e+00
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -4.622002
p-value                         0.000118
#Lags Used                      7.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -5.925331e+00
p-value                        2.451378e-07
#Lags Used                     4.000000e+00
Number of Observations Used    3.700000e+01
Critical Value (1%)           -3.620918e+00
Critical Value (5%)           -2.943539e+00
Critical Value (10%)          -2.610400e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -4.625403
p-value                         0.000116
#Lags Used                      6.000000
Number of Observations Used    35.000000
Critical Value (1%)            -3.632743
Critical Value (5%)            -2.948510
Critical Value (10%)           -2.613017
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                -6.571398e+00
p-value                        7.919514e-09
#Lags Used                     1.000000e+00
Number of Observations Used    4.000000e+01
Critical Value (1%)           -3.605565e+00
Critical Value (5%)           -2.937069e+00
Critical Value (10%)          -2.606986e+00
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                 -5.439347
p-value                         0.000003
#Lags Used                      3.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                -6.964733e+00
p-value                        8.975526e-10
#Lags Used                     1.000000e+00
Number of Observations Used    4.000000e+01
Critical Value (1%)           -3.605565e+00
Critical Value (5%)           -2.937069e+00
Critical Value (10%)          -2.606986e+00
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                -9.241399e+00
p-value                        1.578993e-15
#Lags Used                     1.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -5.561993
p-value                         0.000002
#Lags Used                      3.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                -6.440265e+00
p-value                        1.614666e-08
#Lags Used                     2.000000e+00
Number of Observations Used    3.600000e+01
Critical Value (1%)           -3.626652e+00
Critical Value (5%)           -2.945951e+00
Critical Value (10%)          -2.611671e+00
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                -8.323485e+00
p-value                        3.521067e-13
#Lags Used                     1.000000e+00
Number of Observations Used    3.700000e+01
Critical Value (1%)           -3.620918e+00
Critical Value (5%)           -2.943539e+00
Critical Value (10%)          -2.610400e+00
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -5.255276
p-value                         0.000007
#Lags Used                      3.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -4.137810
p-value                         0.000838
#Lags Used                      9.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.053542
p-value                         0.001155
#Lags Used                      5.000000
Number of Observations Used    28.000000
Critical Value (1%)            -3.688926
Critical Value (5%)            -2.971989
Critical Value (10%)           -2.625296
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                 -3.595170
p-value                         0.005854
#Lags Used                      9.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

7. Differencing Transformation (Shift 2)

In [20]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_diff2=d_it.diff(periods=2)
    demand_diff2.dropna(inplace=True)
    test_stationarity(demand_diff2,'Differencing Transformation (Shift 2)',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -9.296387e+00
p-value                        1.143133e-15
#Lags Used                     3.000000e+00
Number of Observations Used    9.500000e+01
Critical Value (1%)           -3.501137e+00
Critical Value (5%)           -2.892480e+00
Critical Value (10%)          -2.583275e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                 -4.193586
p-value                         0.000676
#Lags Used                      8.000000
Number of Observations Used    82.000000
Critical Value (1%)            -3.512738
Critical Value (5%)            -2.897490
Critical Value (10%)           -2.585949
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                -5.917606e+00
p-value                        2.550853e-07
#Lags Used                     5.000000e+00
Number of Observations Used    8.300000e+01
Critical Value (1%)           -3.511712e+00
Critical Value (5%)           -2.897048e+00
Critical Value (10%)          -2.585713e+00
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                 -4.846790
p-value                         0.000044
#Lags Used                      9.000000
Number of Observations Used    77.000000
Critical Value (1%)            -3.518281
Critical Value (5%)            -2.899878
Critical Value (10%)           -2.587223
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.776885
p-value                         0.000060
#Lags Used                     11.000000
Number of Observations Used    66.000000
Critical Value (1%)            -3.533560
Critical Value (5%)            -2.906444
Critical Value (10%)           -2.590724
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                 -4.987508
p-value                         0.000023
#Lags Used                      3.000000
Number of Observations Used    71.000000
Critical Value (1%)            -3.526005
Critical Value (5%)            -2.903200
Critical Value (10%)           -2.588995
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                 -3.637231
p-value                         0.005088
#Lags Used                      9.000000
Number of Observations Used    58.000000
Critical Value (1%)            -3.548494
Critical Value (5%)            -2.912837
Critical Value (10%)           -2.594129
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -8.125377e+00
p-value                        1.126886e-12
#Lags Used                     3.000000e+00
Number of Observations Used    6.300000e+01
Critical Value (1%)           -3.538695e+00
Critical Value (5%)           -2.908645e+00
Critical Value (10%)          -2.591897e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                -5.989405e+00
p-value                        1.760279e-07
#Lags Used                     5.000000e+00
Number of Observations Used    6.100000e+01
Critical Value (1%)           -3.542413e+00
Critical Value (5%)           -2.910236e+00
Critical Value (10%)          -2.592745e+00
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                -9.381240e+00
p-value                        6.948076e-16
#Lags Used                     1.000000e+00
Number of Observations Used    5.400000e+01
Critical Value (1%)           -3.557709e+00
Critical Value (5%)           -2.916770e+00
Critical Value (10%)          -2.596222e+00
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                -7.654559e+00
p-value                        1.752980e-11
#Lags Used                     3.000000e+00
Number of Observations Used    5.200000e+01
Critical Value (1%)           -3.562879e+00
Critical Value (5%)           -2.918973e+00
Critical Value (10%)          -2.597393e+00
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                 -4.877436
p-value                         0.000039
#Lags Used                      5.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                -6.573929e+00
p-value                        7.810811e-09
#Lags Used                     3.000000e+00
Number of Observations Used    4.400000e+01
Critical Value (1%)           -3.588573e+00
Critical Value (5%)           -2.929886e+00
Critical Value (10%)          -2.603185e+00
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.871072
p-value                         0.000040
#Lags Used                      3.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -5.028959
p-value                         0.000019
#Lags Used                      2.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -5.012617
p-value                         0.000021
#Lags Used                      3.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.527661
p-value                         0.000002
#Lags Used                      3.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.633816e+00
p-value                        5.627883e-09
#Lags Used                     3.000000e+00
Number of Observations Used    3.700000e+01
Critical Value (1%)           -3.620918e+00
Critical Value (5%)           -2.943539e+00
Critical Value (10%)          -2.610400e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -5.046527
p-value                         0.000018
#Lags Used                      5.000000
Number of Observations Used    35.000000
Critical Value (1%)            -3.632743
Critical Value (5%)            -2.948510
Critical Value (10%)           -2.613017
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.573089
p-value                         0.000145
#Lags Used                      5.000000
Number of Observations Used    35.000000
Critical Value (1%)            -3.632743
Critical Value (5%)            -2.948510
Critical Value (10%)           -2.613017
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -7.416198e+00
p-value                        6.925142e-11
#Lags Used                     1.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.728498
p-value                         0.000074
#Lags Used                      5.000000
Number of Observations Used    35.000000
Critical Value (1%)            -3.632743
Critical Value (5%)            -2.948510
Critical Value (10%)           -2.613017
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                 -4.566038
p-value                         0.000149
#Lags Used                      3.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                -8.387585e+00
p-value                        2.414927e-13
#Lags Used                     1.000000e+00
Number of Observations Used    3.700000e+01
Critical Value (1%)           -3.620918e+00
Critical Value (5%)           -2.943539e+00
Critical Value (10%)          -2.610400e+00
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -4.123739
p-value                         0.000885
#Lags Used                      6.000000
Number of Observations Used    31.000000
Critical Value (1%)            -3.661429
Critical Value (5%)            -2.960525
Critical Value (10%)           -2.619319
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                -7.372472e+00
p-value                        8.897381e-11
#Lags Used                     1.000000e+00
Number of Observations Used    3.600000e+01
Critical Value (1%)           -3.626652e+00
Critical Value (5%)           -2.945951e+00
Critical Value (10%)          -2.611671e+00
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.913972
p-value                         0.000033
#Lags Used                      3.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -4.105883
p-value                         0.000947
#Lags Used                      8.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.396792
p-value                         0.000301
#Lags Used                      5.000000
Number of Observations Used    27.000000
Critical Value (1%)            -3.699608
Critical Value (5%)            -2.976430
Critical Value (10%)           -2.627601
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                 -1.388340
p-value                         0.587853
#Lags Used                     10.000000
Number of Observations Used    22.000000
Critical Value (1%)            -3.769733
Critical Value (5%)            -3.005426
Critical Value (10%)           -2.642501
dtype: float64

------------------------------------------------------

8. Differencing Transformation (Shift 3)

In [21]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_diff3=d_it.diff(periods=3)
    demand_diff3.dropna(inplace=True)
    test_stationarity(demand_diff3,'Differencing Transformation (Shift 3)',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -1.040467e+01
p-value                        1.870242e-18
#Lags Used                     2.000000e+00
Number of Observations Used    9.500000e+01
Critical Value (1%)           -3.501137e+00
Critical Value (5%)           -2.892480e+00
Critical Value (10%)          -2.583275e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                 -3.340325
p-value                         0.013169
#Lags Used                     10.000000
Number of Observations Used    79.000000
Critical Value (1%)            -3.515977
Critical Value (5%)            -2.898886
Critical Value (10%)           -2.586694
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                -6.870107e+00
p-value                        1.523337e-09
#Lags Used                     5.000000e+00
Number of Observations Used    8.200000e+01
Critical Value (1%)           -3.512738e+00
Critical Value (5%)           -2.897490e+00
Critical Value (10%)          -2.585949e+00
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                 -5.225880
p-value                         0.000008
#Lags Used                      8.000000
Number of Observations Used    77.000000
Critical Value (1%)            -3.518281
Critical Value (5%)            -2.899878
Critical Value (10%)           -2.587223
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                -7.317970e+00
p-value                        1.215119e-10
#Lags Used                     2.000000e+00
Number of Observations Used    7.400000e+01
Critical Value (1%)           -3.521980e+00
Critical Value (5%)           -2.901470e+00
Critical Value (10%)          -2.588072e+00
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                 -3.839701
p-value                         0.002526
#Lags Used                      8.000000
Number of Observations Used    65.000000
Critical Value (1%)            -3.535217
Critical Value (5%)            -2.907154
Critical Value (10%)           -2.591103
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -8.776273e+00
p-value                        2.444053e-14
#Lags Used                     2.000000e+00
Number of Observations Used    6.400000e+01
Critical Value (1%)           -3.536928e+00
Critical Value (5%)           -2.907887e+00
Critical Value (10%)          -2.591493e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                 -4.355187
p-value                         0.000356
#Lags Used                      7.000000
Number of Observations Used    58.000000
Critical Value (1%)            -3.548494
Critical Value (5%)            -2.912837
Critical Value (10%)           -2.594129
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -3.373680
p-value                         0.011890
#Lags Used                      6.000000
Number of Observations Used    59.000000
Critical Value (1%)            -3.546395
Critical Value (5%)            -2.911939
Critical Value (10%)           -2.593652
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                 -4.519448
p-value                         0.000181
#Lags Used                      5.000000
Number of Observations Used    49.000000
Critical Value (1%)            -3.571472
Critical Value (5%)            -2.922629
Critical Value (10%)           -2.599336
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                -9.518801e+00
p-value                        3.104775e-16
#Lags Used                     2.000000e+00
Number of Observations Used    5.200000e+01
Critical Value (1%)           -3.562879e+00
Critical Value (5%)           -2.918973e+00
Critical Value (10%)          -2.597393e+00
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                 -4.761290
p-value                         0.000064
#Lags Used                      5.000000
Number of Observations Used    43.000000
Critical Value (1%)            -3.592504
Critical Value (5%)            -2.931550
Critical Value (10%)           -2.604066
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -4.888545
p-value                         0.000037
#Lags Used                      5.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.294332
p-value                         0.015134
#Lags Used                      5.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -4.069990
p-value                         0.001085
#Lags Used                      5.000000
Number of Observations Used    37.000000
Critical Value (1%)            -3.620918
Critical Value (5%)            -2.943539
Critical Value (10%)           -2.610400
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -3.776539
p-value                         0.003157
#Lags Used                      5.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.264177
p-value                         0.000006
#Lags Used                      5.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -7.603626e+00
p-value                        2.353533e-11
#Lags Used                     2.000000e+00
Number of Observations Used    3.700000e+01
Critical Value (1%)           -3.620918e+00
Critical Value (5%)           -2.943539e+00
Critical Value (10%)          -2.610400e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -4.481478
p-value                         0.000212
#Lags Used                      5.000000
Number of Observations Used    34.000000
Critical Value (1%)            -3.639224
Critical Value (5%)            -2.951230
Critical Value (10%)           -2.614447
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.221601
p-value                         0.000606
#Lags Used                      5.000000
Number of Observations Used    34.000000
Critical Value (1%)            -3.639224
Critical Value (5%)            -2.951230
Critical Value (10%)           -2.614447
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                 -4.630791
p-value                         0.000113
#Lags Used                      5.000000
Number of Observations Used    34.000000
Critical Value (1%)            -3.639224
Critical Value (5%)            -2.951230
Critical Value (10%)           -2.614447
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -2.457501
p-value                         0.126160
#Lags Used                      6.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                 -4.823359
p-value                         0.000049
#Lags Used                      2.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                -5.746801e+00
p-value                        6.094875e-07
#Lags Used                     1.000000e+01
Number of Observations Used    2.700000e+01
Critical Value (1%)           -3.699608e+00
Critical Value (5%)           -2.976430e+00
Critical Value (10%)          -2.627601e+00
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -3.574021
p-value                         0.006278
#Lags Used                      7.000000
Number of Observations Used    29.000000
Critical Value (1%)            -3.679060
Critical Value (5%)            -2.967882
Critical Value (10%)           -2.623158
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                 -5.107507
p-value                         0.000014
#Lags Used                      0.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -2.510398
p-value                         0.112965
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -5.099034
p-value                         0.000014
#Lags Used                      6.000000
Number of Observations Used    25.000000
Critical Value (1%)            -3.723863
Critical Value (5%)            -2.986489
Critical Value (10%)           -2.632800
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -5.621719
p-value                         0.000001
#Lags Used                      1.000000
Number of Observations Used    30.000000
Critical Value (1%)            -3.669920
Critical Value (5%)            -2.964071
Critical Value (10%)           -2.621171
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                 -1.092001
p-value                         0.718251
#Lags Used                     10.000000
Number of Observations Used    21.000000
Critical Value (1%)            -3.788386
Critical Value (5%)            -3.013098
Critical Value (10%)           -2.646397
dtype: float64

------------------------------------------------------

9. Power Transformation ( Box-Cox )

In [22]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values   
    scaler=PowerTransformer(method='box-cox')
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_pow_bc=demand_nor.flatten()
    demand_pow_bc=pd.Series(demand_pow_bc,index=index)
    test_stationarity(demand_pow_bc,'Power Transformation ( Box-Cox )',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.523809e+00
p-value                        1.026460e-08
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                 -3.498436
p-value                         0.008027
#Lags Used                      2.000000
Number of Observations Used    90.000000
Critical Value (1%)            -3.505190
Critical Value (5%)            -2.894232
Critical Value (10%)           -2.584210
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.628923
p-value                         0.000114
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.313444e+00
p-value                        1.246936e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.098761
p-value                         0.026645
#Lags Used                      2.000000
Number of Observations Used    77.000000
Critical Value (1%)            -3.518281
Critical Value (5%)            -2.899878
Critical Value (10%)           -2.587223
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                 -3.765816
p-value                         0.003277
#Lags Used                      1.000000
Number of Observations Used    75.000000
Critical Value (1%)            -3.520713
Critical Value (5%)            -2.900925
Critical Value (10%)           -2.587781
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.113302e+00
p-value                        9.221439e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -6.020916e+00
p-value                        1.494508e-07
#Lags Used                     1.000000e+00
Number of Observations Used    6.700000e+01
Critical Value (1%)           -3.531955e+00
Critical Value (5%)           -2.905755e+00
Critical Value (10%)          -2.590357e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -5.489681
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    68.000000
Critical Value (1%)            -3.530399
Critical Value (5%)            -2.905087
Critical Value (10%)           -2.590001
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                 -5.247308
p-value                         0.000007
#Lags Used                      0.000000
Number of Observations Used    57.000000
Critical Value (1%)            -3.550670
Critical Value (5%)            -2.913766
Critical Value (10%)           -2.594624
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -3.485476
p-value                         0.008368
#Lags Used                      7.000000
Number of Observations Used    50.000000
Critical Value (1%)            -3.568486
Critical Value (5%)            -2.921360
Critical Value (10%)           -2.598662
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.492547e+00
p-value                        1.301654e-13
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.208725
p-value                         0.019485
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.575084
p-value                         0.006256
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -2.274544
p-value                         0.180309
#Lags Used                      6.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.184429e+00
p-value                        6.339761e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.400000e+01
Critical Value (1%)           -3.588573e+00
Critical Value (5%)           -2.929886e+00
Critical Value (10%)          -2.603185e+00
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.484945
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.877084e+00
p-value                        1.465213e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.851845e+00
p-value                        1.686461e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.196904
p-value                         0.000667
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.914479e+00
p-value                        2.592240e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                -5.816877e+00
p-value                        4.272038e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                 -5.392282
p-value                         0.000004
#Lags Used                      1.000000
Number of Observations Used    40.000000
Critical Value (1%)            -3.605565
Critical Value (5%)            -2.937069
Critical Value (10%)           -2.606986
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -4.796643
p-value                         0.000055
#Lags Used                      2.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -4.062988
p-value                         0.001114
#Lags Used                      1.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                 -3.556459
p-value                         0.006650
#Lags Used                      8.000000
Number of Observations Used    31.000000
Critical Value (1%)            -3.661429
Critical Value (5%)            -2.960525
Critical Value (10%)           -2.619319
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -5.199699
p-value                         0.000009
#Lags Used                      0.000000
Number of Observations Used    37.000000
Critical Value (1%)            -3.620918
Critical Value (5%)            -2.943539
Critical Value (10%)           -2.610400
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.237879
p-value                         0.017894
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.182487
p-value                         0.000705
#Lags Used                      0.000000
Number of Observations Used    34.000000
Critical Value (1%)            -3.639224
Critical Value (5%)            -2.951230
Critical Value (10%)           -2.614447
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.629132
p-value                         0.988312
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

10. Power Transformation ( Yeo-Johnson )

In [23]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values   
    scaler=PowerTransformer(method='yeo-johnson')
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_pow_yj=demand_nor.flatten()
    demand_pow_yj=pd.Series(demand_pow_yj,index=index)
    test_stationarity(demand_pow_yj,'Power Transformation ( Yeo-Johnson )',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.491133e+00
p-value                        1.225874e-08
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                 -3.476254
p-value                         0.008618
#Lags Used                      2.000000
Number of Observations Used    90.000000
Critical Value (1%)            -3.505190
Critical Value (5%)            -2.894232
Critical Value (10%)           -2.584210
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.617498
p-value                         0.000120
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.278128e+00
p-value                        1.525299e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.123420
p-value                         0.024868
#Lags Used                      2.000000
Number of Observations Used    77.000000
Critical Value (1%)            -3.518281
Critical Value (5%)            -2.899878
Critical Value (10%)           -2.587223
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                 -3.758506
p-value                         0.003362
#Lags Used                      1.000000
Number of Observations Used    75.000000
Critical Value (1%)            -3.520713
Critical Value (5%)            -2.900925
Critical Value (10%)           -2.587781
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.130372e+00
p-value                        8.430372e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -5.990770e+00
p-value                        1.747861e-07
#Lags Used                     1.000000e+00
Number of Observations Used    6.700000e+01
Critical Value (1%)           -3.531955e+00
Critical Value (5%)           -2.905755e+00
Critical Value (10%)          -2.590357e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -5.460223
p-value                         0.000003
#Lags Used                      0.000000
Number of Observations Used    68.000000
Critical Value (1%)            -3.530399
Critical Value (5%)            -2.905087
Critical Value (10%)           -2.590001
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                 -5.264989
p-value                         0.000006
#Lags Used                      0.000000
Number of Observations Used    57.000000
Critical Value (1%)            -3.550670
Critical Value (5%)            -2.913766
Critical Value (10%)           -2.594624
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -3.443774
p-value                         0.009554
#Lags Used                      7.000000
Number of Observations Used    50.000000
Critical Value (1%)            -3.568486
Critical Value (5%)            -2.921360
Critical Value (10%)           -2.598662
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.479269e+00
p-value                        1.407544e-13
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.232371
p-value                         0.018186
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.559742
p-value                         0.006579
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -2.285026
p-value                         0.176843
#Lags Used                      6.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.134427e+00
p-value                        8.252462e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.400000e+01
Critical Value (1%)           -3.588573e+00
Critical Value (5%)           -2.929886e+00
Critical Value (10%)          -2.603185e+00
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.482635
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.818338e+00
p-value                        2.031924e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.876397e+00
p-value                        1.470840e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.229853
p-value                         0.000586
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.913898e+00
p-value                        2.600002e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                -5.812958e+00
p-value                        4.358121e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                 -5.401346
p-value                         0.000003
#Lags Used                      1.000000
Number of Observations Used    40.000000
Critical Value (1%)            -3.605565
Critical Value (5%)            -2.937069
Critical Value (10%)           -2.606986
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -4.756976
p-value                         0.000066
#Lags Used                      2.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -4.077394
p-value                         0.001055
#Lags Used                      1.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                 -3.555554
p-value                         0.006670
#Lags Used                      8.000000
Number of Observations Used    31.000000
Critical Value (1%)            -3.661429
Critical Value (5%)            -2.960525
Critical Value (10%)           -2.619319
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -5.165982
p-value                         0.000010
#Lags Used                      0.000000
Number of Observations Used    37.000000
Critical Value (1%)            -3.620918
Critical Value (5%)            -2.943539
Critical Value (10%)           -2.610400
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.236785
p-value                         0.017952
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.156757
p-value                         0.000779
#Lags Used                      0.000000
Number of Observations Used    34.000000
Critical Value (1%)            -3.639224
Critical Value (5%)            -2.951230
Critical Value (10%)           -2.614447
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.653580
p-value                         0.988864
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

11. MaxAbsScaler Transformation

In [24]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=MaxAbsScaler()
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_abs=demand_nor.flatten()
    demand_abs=pd.Series(demand_abs,index=index)
    test_stationarity(demand_abs,'MaxAbsScaler Transformation',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -8.064442e+00
p-value                        1.610355e-12
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                -5.692333e+00
p-value                        8.017971e-07
#Lags Used                     0.000000e+00
Number of Observations Used    9.200000e+01
Critical Value (1%)           -3.503515e+00
Critical Value (5%)           -2.893508e+00
Critical Value (10%)          -2.583824e+00
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.477390
p-value                         0.000216
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.248987e+00
p-value                        1.800750e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                -6.332940e+00
p-value                        2.876519e-08
#Lags Used                     0.000000e+00
Number of Observations Used    7.900000e+01
Critical Value (1%)           -3.515977e+00
Critical Value (5%)           -2.898886e+00
Critical Value (10%)          -2.586694e+00
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                -5.950297e+00
p-value                        2.155174e-07
#Lags Used                     0.000000e+00
Number of Observations Used    7.600000e+01
Critical Value (1%)           -3.519481e+00
Critical Value (5%)           -2.900395e+00
Critical Value (10%)          -2.587498e+00
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.215294e+00
p-value                        5.384224e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -5.721408e+00
p-value                        6.927615e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -5.096311
p-value                         0.000014
#Lags Used                      1.000000
Number of Observations Used    67.000000
Critical Value (1%)            -3.531955
Critical Value (5%)            -2.905755
Critical Value (10%)           -2.590357
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                -5.902054e+00
p-value                        2.763263e-07
#Lags Used                     0.000000e+00
Number of Observations Used    5.700000e+01
Critical Value (1%)           -3.550670e+00
Critical Value (5%)           -2.913766e+00
Critical Value (10%)          -2.594624e+00
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -2.737167
p-value                         0.067825
#Lags Used                      5.000000
Number of Observations Used    52.000000
Critical Value (1%)            -3.562879
Critical Value (5%)            -2.918973
Critical Value (10%)           -2.597393
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.589371e+00
p-value                        7.357021e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.474673
p-value                         0.008662
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.272182
p-value                         0.016169
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -2.124539
p-value                         0.234763
#Lags Used                      4.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -4.427601
p-value                         0.000265
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.583107
p-value                         0.000001
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.510337e+00
p-value                        1.104471e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.638242e+00
p-value                        5.492855e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.886284
p-value                         0.000037
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.691809e+00
p-value                        8.039062e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.964913
p-value                         0.000026
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                -7.146346e+00
p-value                        3.225321e-10
#Lags Used                     0.000000e+00
Number of Observations Used    4.100000e+01
Critical Value (1%)           -3.600983e+00
Critical Value (5%)           -2.935135e+00
Critical Value (10%)          -2.605963e+00
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -4.764090
p-value                         0.000064
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                -5.685763e+00
p-value                        8.286640e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                -5.701978e+00
p-value                        7.638881e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.579822
p-value                         0.000141
#Lags Used                      1.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -2.908719
p-value                         0.044343
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.423987
p-value                         0.000269
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.971853
p-value                         0.993960
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

12. Robust Scaler Transformation

In [25]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=RobustScaler()
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_rs=demand_nor.flatten()
    demand_rs=pd.Series(demand_rs,index=index)
    test_stationarity(demand_rs,'Robust Scaler Transformation',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -8.064442e+00
p-value                        1.610355e-12
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                -5.692333e+00
p-value                        8.017971e-07
#Lags Used                     0.000000e+00
Number of Observations Used    9.200000e+01
Critical Value (1%)           -3.503515e+00
Critical Value (5%)           -2.893508e+00
Critical Value (10%)          -2.583824e+00
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.477390
p-value                         0.000216
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.248987e+00
p-value                        1.800750e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                -6.332940e+00
p-value                        2.876519e-08
#Lags Used                     0.000000e+00
Number of Observations Used    7.900000e+01
Critical Value (1%)           -3.515977e+00
Critical Value (5%)           -2.898886e+00
Critical Value (10%)          -2.586694e+00
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                -5.950297e+00
p-value                        2.155174e-07
#Lags Used                     0.000000e+00
Number of Observations Used    7.600000e+01
Critical Value (1%)           -3.519481e+00
Critical Value (5%)           -2.900395e+00
Critical Value (10%)          -2.587498e+00
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.215294e+00
p-value                        5.384224e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -5.721408e+00
p-value                        6.927615e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -5.096311
p-value                         0.000014
#Lags Used                      1.000000
Number of Observations Used    67.000000
Critical Value (1%)            -3.531955
Critical Value (5%)            -2.905755
Critical Value (10%)           -2.590357
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                -5.902054e+00
p-value                        2.763263e-07
#Lags Used                     0.000000e+00
Number of Observations Used    5.700000e+01
Critical Value (1%)           -3.550670e+00
Critical Value (5%)           -2.913766e+00
Critical Value (10%)          -2.594624e+00
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -2.737167
p-value                         0.067825
#Lags Used                      5.000000
Number of Observations Used    52.000000
Critical Value (1%)            -3.562879
Critical Value (5%)            -2.918973
Critical Value (10%)           -2.597393
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.589371e+00
p-value                        7.357021e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.474673
p-value                         0.008662
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.272182
p-value                         0.016169
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -2.124539
p-value                         0.234763
#Lags Used                      4.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -4.427601
p-value                         0.000265
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.583107
p-value                         0.000001
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.510337e+00
p-value                        1.104471e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.638242e+00
p-value                        5.492855e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.886284
p-value                         0.000037
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.691809e+00
p-value                        8.039062e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.964913
p-value                         0.000026
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                -7.146346e+00
p-value                        3.225321e-10
#Lags Used                     0.000000e+00
Number of Observations Used    4.100000e+01
Critical Value (1%)           -3.600983e+00
Critical Value (5%)           -2.935135e+00
Critical Value (10%)          -2.605963e+00
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -4.764090
p-value                         0.000064
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                -5.685763e+00
p-value                        8.286640e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                -5.701978e+00
p-value                        7.638881e-07
#Lags Used                     0.000000e+00
Number of Observations Used    3.900000e+01
Critical Value (1%)           -3.610400e+00
Critical Value (5%)           -2.939109e+00
Critical Value (10%)          -2.608063e+00
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.579822
p-value                         0.000141
#Lags Used                      1.000000
Number of Observations Used    36.000000
Critical Value (1%)            -3.626652
Critical Value (5%)            -2.945951
Critical Value (10%)           -2.611671
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -2.908719
p-value                         0.044343
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.423987
p-value                         0.000269
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.971853
p-value                         0.993960
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

13. Quantile Transformation ( Uniform )

In [26]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=QuantileTransformer(output_distribution='uniform')
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_qtu=demand_nor.flatten()
    demand_qtu=pd.Series(demand_qtu,index=index)
    test_stationarity(demand_qtu,'Quantile Transformation ( Uniform )',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                 -4.475395
p-value                         0.000218
#Lags Used                      1.000000
Number of Observations Used    99.000000
Critical Value (1%)            -3.498198
Critical Value (5%)            -2.891208
Critical Value (10%)           -2.582596
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                 -3.487153
p-value                         0.008323
#Lags Used                      2.000000
Number of Observations Used    90.000000
Critical Value (1%)            -3.505190
Critical Value (5%)            -2.894232
Critical Value (10%)           -2.584210
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -2.659006
p-value                         0.081405
#Lags Used                      3.000000
Number of Observations Used    87.000000
Critical Value (1%)            -3.507853
Critical Value (5%)            -2.895382
Critical Value (10%)           -2.584824
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.326272e+00
p-value                        1.158841e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.021938
p-value                         0.032896
#Lags Used                      2.000000
Number of Observations Used    77.000000
Critical Value (1%)            -3.518281
Critical Value (5%)            -2.899878
Critical Value (10%)           -2.587223
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                 -3.733283
p-value                         0.003669
#Lags Used                      1.000000
Number of Observations Used    75.000000
Critical Value (1%)            -3.520713
Critical Value (5%)            -2.900925
Critical Value (10%)           -2.587781
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.056229e+00
p-value                        1.243281e-07
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -6.065767e+00
p-value                        1.182862e-07
#Lags Used                     1.000000e+00
Number of Observations Used    6.700000e+01
Critical Value (1%)           -3.531955e+00
Critical Value (5%)           -2.905755e+00
Critical Value (10%)          -2.590357e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                -5.815147e+00
p-value                        4.309823e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                 -5.257207
p-value                         0.000007
#Lags Used                      0.000000
Number of Observations Used    57.000000
Critical Value (1%)            -3.550670
Critical Value (5%)            -2.913766
Critical Value (10%)           -2.594624
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -3.677030
p-value                         0.004448
#Lags Used                      4.000000
Number of Observations Used    53.000000
Critical Value (1%)            -3.560242
Critical Value (5%)            -2.917850
Critical Value (10%)           -2.596796
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.368105e+00
p-value                        2.708237e-13
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -0.581412
p-value                         0.875127
#Lags Used                     11.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.519903
p-value                         0.007490
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -2.272500
p-value                         0.180991
#Lags Used                      6.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.277968e+00
p-value                        3.858652e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.400000e+01
Critical Value (1%)           -3.588573e+00
Critical Value (5%)           -2.929886e+00
Critical Value (10%)          -2.603185e+00
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.470662
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.913274e+00
p-value                        1.197178e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.852308e+00
p-value                        1.682122e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.098984
p-value                         0.000972
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.903442e+00
p-value                        2.743624e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                -5.874856e+00
p-value                        3.177103e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                 -5.437046
p-value                         0.000003
#Lags Used                      1.000000
Number of Observations Used    40.000000
Critical Value (1%)            -3.605565
Critical Value (5%)            -2.937069
Critical Value (10%)           -2.606986
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -4.873528
p-value                         0.000039
#Lags Used                      2.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -4.133415
p-value                         0.000852
#Lags Used                      1.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                 -3.599300
p-value                         0.005774
#Lags Used                      7.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -5.222673
p-value                         0.000008
#Lags Used                      0.000000
Number of Observations Used    37.000000
Critical Value (1%)            -3.620918
Critical Value (5%)            -2.943539
Critical Value (10%)           -2.610400
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.207244
p-value                         0.019569
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.148509
p-value                         0.000804
#Lags Used                      0.000000
Number of Observations Used    34.000000
Critical Value (1%)            -3.639224
Critical Value (5%)            -2.951230
Critical Value (10%)           -2.614447
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.653463
p-value                         0.988862
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

14. Quantile Transformation ( Normal )

In [27]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=QuantileTransformer(output_distribution='normal')
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_qtn=demand_nor.flatten()
    demand_qtn=pd.Series(demand_qtn,index=index)
    test_stationarity(demand_qtn,'Quantile Transformation ( Normal )',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.982529e+00
p-value                        8.122837e-10
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                -7.158050e+00
p-value                        3.018408e-10
#Lags Used                     0.000000e+00
Number of Observations Used    9.200000e+01
Critical Value (1%)           -3.503515e+00
Critical Value (5%)           -2.893508e+00
Critical Value (10%)          -2.583824e+00
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -2.832395
p-value                         0.053793
#Lags Used                      3.000000
Number of Observations Used    87.000000
Critical Value (1%)            -3.507853
Critical Value (5%)            -2.895382
Critical Value (10%)           -2.584824
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -8.324970e+00
p-value                        3.490444e-13
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                 -2.097310
p-value                         0.245598
#Lags Used                      5.000000
Number of Observations Used    74.000000
Critical Value (1%)            -3.521980
Critical Value (5%)            -2.901470
Critical Value (10%)           -2.588072
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                 -3.985231
p-value                         0.001490
#Lags Used                      1.000000
Number of Observations Used    75.000000
Critical Value (1%)            -3.520713
Critical Value (5%)            -2.900925
Critical Value (10%)           -2.587781
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -5.698197e+00
p-value                        7.785353e-07
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -6.169403e+00
p-value                        6.863436e-08
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -2.832855
p-value                         0.053732
#Lags Used                      4.000000
Number of Observations Used    64.000000
Critical Value (1%)            -3.536928
Critical Value (5%)            -2.907887
Critical Value (10%)           -2.591493
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                 -5.510718
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    57.000000
Critical Value (1%)            -3.550670
Critical Value (5%)            -2.913766
Critical Value (10%)           -2.594624
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -3.681572
p-value                         0.004380
#Lags Used                      4.000000
Number of Observations Used    53.000000
Critical Value (1%)            -3.560242
Critical Value (5%)            -2.917850
Critical Value (10%)           -2.596796
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.768526e+00
p-value                        2.558296e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -0.489946
p-value                         0.893964
#Lags Used                     11.000000
Number of Observations Used    38.000000
Critical Value (1%)            -3.615509
Critical Value (5%)            -2.941262
Critical Value (10%)           -2.609200
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.320768
p-value                         0.013975
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -2.139213
p-value                         0.229042
#Lags Used                      6.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.249875e+00
p-value                        4.481160e-08
#Lags Used                     0.000000e+00
Number of Observations Used    4.400000e+01
Critical Value (1%)           -3.588573e+00
Critical Value (5%)           -2.929886e+00
Critical Value (10%)          -2.603185e+00
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.513624
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -7.467321e+00
p-value                        5.163333e-11
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.706767e+00
p-value                        3.767905e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.292763
p-value                         0.000457
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.790249e+00
p-value                        4.891275e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -5.564995
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                 -5.453340
p-value                         0.000003
#Lags Used                      1.000000
Number of Observations Used    40.000000
Critical Value (1%)            -3.605565
Critical Value (5%)            -2.937069
Critical Value (10%)           -2.606986
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -5.111992
p-value                         0.000013
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -4.698606
p-value                         0.000085
#Lags Used                      0.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                 -3.542191
p-value                         0.006967
#Lags Used                      7.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.944830
p-value                         0.000029
#Lags Used                      0.000000
Number of Observations Used    37.000000
Critical Value (1%)            -3.620918
Critical Value (5%)            -2.943539
Critical Value (10%)           -2.610400
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -2.844839
p-value                         0.052149
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -3.986810
p-value                         0.001481
#Lags Used                      0.000000
Number of Observations Used    34.000000
Critical Value (1%)            -3.639224
Critical Value (5%)            -2.951230
Critical Value (10%)           -2.614447
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.942548
p-value                         0.993621
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

15. Function Transformation

In [28]:
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=FunctionTransformer(np.log1p)
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_ft=demand_nor.flatten()
    demand_ft=pd.Series(demand_ft,index=index)
    test_stationarity(demand_ft,'Function Transformation',i)
    print('\n------------------------------------------------------\n')
Sales Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.595362e+00
p-value                        6.947384e-09
#Lags Used                     0.000000e+00
Number of Observations Used    1.000000e+02
Critical Value (1%)           -3.497501e+00
Critical Value (5%)           -2.890906e+00
Critical Value (10%)          -2.582435e+00
dtype: float64

------------------------------------------------------

Software/Application Developer
Results of Dickey-Fuller Test:
Test Statistic                -5.787423e+00
p-value                        4.961947e-07
#Lags Used                     0.000000e+00
Number of Observations Used    9.200000e+01
Critical Value (1%)           -3.503515e+00
Critical Value (5%)           -2.893508e+00
Critical Value (10%)          -2.583824e+00
dtype: float64

------------------------------------------------------

Sales Development Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.637754
p-value                         0.000110
#Lags Used                      1.000000
Number of Observations Used    89.000000
Critical Value (1%)            -3.506057
Critical Value (5%)            -2.894607
Critical Value (10%)           -2.584410
dtype: float64

------------------------------------------------------

General and Operations manager
Results of Dickey-Fuller Test:
Test Statistic                -7.213869e+00
p-value                        2.198893e-10
#Lags Used                     0.000000e+00
Number of Observations Used    8.800000e+01
Critical Value (1%)           -3.506944e+00
Critical Value (5%)           -2.894990e+00
Critical Value (10%)          -2.584615e+00
dtype: float64

------------------------------------------------------

Customer Service Representative
Results of Dickey-Fuller Test:
Test Statistic                 -4.181986
p-value                         0.000707
#Lags Used                      1.000000
Number of Observations Used    78.000000
Critical Value (1%)            -3.517114
Critical Value (5%)            -2.899375
Critical Value (10%)           -2.586955
dtype: float64

------------------------------------------------------

Accountant
Results of Dickey-Fuller Test:
Test Statistic                -5.674855e+00
p-value                        8.752258e-07
#Lags Used                     0.000000e+00
Number of Observations Used    7.600000e+01
Critical Value (1%)           -3.519481e+00
Critical Value (5%)           -2.900395e+00
Critical Value (10%)          -2.587498e+00
dtype: float64

------------------------------------------------------

Sales Operations Manager
Results of Dickey-Fuller Test:
Test Statistic                -6.175987e+00
p-value                        6.628957e-08
#Lags Used                     1.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Management counsultant
Results of Dickey-Fuller Test:
Test Statistic                -5.681939e+00
p-value                        8.447062e-07
#Lags Used                     0.000000e+00
Number of Observations Used    6.800000e+01
Critical Value (1%)           -3.530399e+00
Critical Value (5%)           -2.905087e+00
Critical Value (10%)          -2.590001e+00
dtype: float64

------------------------------------------------------

Web Developer
Results of Dickey-Fuller Test:
Test Statistic                 -3.332444
p-value                         0.013489
#Lags Used                      2.000000
Number of Observations Used    66.000000
Critical Value (1%)            -3.533560
Critical Value (5%)            -2.906444
Critical Value (10%)           -2.590724
dtype: float64

------------------------------------------------------

Sales Director
Results of Dickey-Fuller Test:
Test Statistic                 -5.559026
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    57.000000
Critical Value (1%)            -3.550670
Critical Value (5%)            -2.913766
Critical Value (10%)           -2.594624
dtype: float64

------------------------------------------------------

Teacher
Results of Dickey-Fuller Test:
Test Statistic                 -2.689811
p-value                         0.075818
#Lags Used                      5.000000
Number of Observations Used    52.000000
Critical Value (1%)            -3.562879
Critical Value (5%)            -2.918973
Critical Value (10%)           -2.597393
dtype: float64

------------------------------------------------------

Skilled Workers
Results of Dickey-Fuller Test:
Test Statistic                -8.577404e+00
p-value                        7.894685e-14
#Lags Used                     0.000000e+00
Number of Observations Used    5.100000e+01
Critical Value (1%)           -3.565624e+00
Critical Value (5%)           -2.920142e+00
Critical Value (10%)          -2.598015e+00
dtype: float64

------------------------------------------------------

Data Entry Operator
Results of Dickey-Fuller Test:
Test Statistic                 -3.409622
p-value                         0.010635
#Lags Used                      4.000000
Number of Observations Used    45.000000
Critical Value (1%)            -3.584829
Critical Value (5%)            -2.928299
Critical Value (10%)           -2.602344
dtype: float64

------------------------------------------------------

Medical Representative
Results of Dickey-Fuller Test:
Test Statistic                 -3.324405
p-value                         0.013822
#Lags Used                      1.000000
Number of Observations Used    46.000000
Critical Value (1%)            -3.581258
Critical Value (5%)            -2.926785
Critical Value (10%)           -2.601541
dtype: float64

------------------------------------------------------

Trainer
Results of Dickey-Fuller Test:
Test Statistic                 -1.915509
p-value                         0.324801
#Lags Used                      4.000000
Number of Observations Used    41.000000
Critical Value (1%)            -3.600983
Critical Value (5%)            -2.935135
Critical Value (10%)           -2.605963
dtype: float64

------------------------------------------------------

Electrial Engineer
Results of Dickey-Fuller Test:
Test Statistic                 -5.002178
p-value                         0.000022
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Graphic Designer
Results of Dickey-Fuller Test:
Test Statistic                 -5.515010
p-value                         0.000002
#Lags Used                      0.000000
Number of Observations Used    44.000000
Critical Value (1%)            -3.588573
Critical Value (5%)            -2.929886
Critical Value (10%)           -2.603185
dtype: float64

------------------------------------------------------

Data Modeler
Results of Dickey-Fuller Test:
Test Statistic                -6.575976e+00
p-value                        7.723975e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Civil Engineer
Results of Dickey-Fuller Test:
Test Statistic                -6.868452e+00
p-value                        1.537449e-09
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Financial Analyst
Results of Dickey-Fuller Test:
Test Statistic                 -4.510703
p-value                         0.000188
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Content Writer
Results of Dickey-Fuller Test:
Test Statistic                -5.779526e+00
p-value                        5.164709e-07
#Lags Used                     0.000000e+00
Number of Observations Used    4.200000e+01
Critical Value (1%)           -3.596636e+00
Critical Value (5%)           -2.933297e+00
Critical Value (10%)          -2.604991e+00
dtype: float64

------------------------------------------------------

Computer Network Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -5.238586
p-value                         0.000007
#Lags Used                      0.000000
Number of Observations Used    42.000000
Critical Value (1%)            -3.596636
Critical Value (5%)            -2.933297
Critical Value (10%)           -2.604991
dtype: float64

------------------------------------------------------

Actuary
Results of Dickey-Fuller Test:
Test Statistic                -7.298372e+00
p-value                        1.358971e-10
#Lags Used                     0.000000e+00
Number of Observations Used    4.100000e+01
Critical Value (1%)           -3.600983e+00
Critical Value (5%)           -2.935135e+00
Critical Value (10%)          -2.605963e+00
dtype: float64

------------------------------------------------------

Investor Relation Associate
Results of Dickey-Fuller Test:
Test Statistic                 -5.367129
p-value                         0.000004
#Lags Used                      1.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

HR Executive
Results of Dickey-Fuller Test:
Test Statistic                 -5.311717
p-value                         0.000005
#Lags Used                      0.000000
Number of Observations Used    39.000000
Critical Value (1%)            -3.610400
Critical Value (5%)            -2.939109
Critical Value (10%)           -2.608063
dtype: float64

------------------------------------------------------

Sales Associate
Results of Dickey-Fuller Test:
Test Statistic                 -3.531212
p-value                         0.007221
#Lags Used                      7.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

Computer Support Specialist
Results of Dickey-Fuller Test:
Test Statistic                 -4.731386
p-value                         0.000073
#Lags Used                      0.000000
Number of Observations Used    37.000000
Critical Value (1%)            -3.620918
Critical Value (5%)            -2.943539
Critical Value (10%)           -2.610400
dtype: float64

------------------------------------------------------

Computer Operator
Results of Dickey-Fuller Test:
Test Statistic                 -2.859568
p-value                         0.050256
#Lags Used                      2.000000
Number of Observations Used    32.000000
Critical Value (1%)            -3.653520
Critical Value (5%)            -2.957219
Critical Value (10%)           -2.617588
dtype: float64

------------------------------------------------------

IT Industry Sales
Results of Dickey-Fuller Test:
Test Statistic                 -4.505874
p-value                         0.000192
#Lags Used                      1.000000
Number of Observations Used    33.000000
Critical Value (1%)            -3.646135
Critical Value (5%)            -2.954127
Critical Value (10%)           -2.615968
dtype: float64

------------------------------------------------------

Receptionist
Results of Dickey-Fuller Test:
Test Statistic                  0.940359
p-value                         0.993595
#Lags Used                     10.000000
Number of Observations Used    24.000000
Critical Value (1%)            -3.737709
Critical Value (5%)            -2.992216
Critical Value (10%)           -2.635747
dtype: float64

------------------------------------------------------

DataFrame consisting Data regarding transformation

In [29]:
stat.head(25) 
Out[29]:
Transformation Job Test Statistic p-value Critical Value (1%) Critical Value (5%)
0 Log Transformation Sales Manager -8.064442 1.610355e-12 -3.497501 -2.890906
1 Log Transformation Software/Application Developer -5.692333 8.017971e-07 -3.503515 -2.893508
2 Log Transformation Sales Development Representative -4.477390 2.159893e-04 -3.506057 -2.894607
3 Log Transformation General and Operations manager -7.248987 1.800750e-10 -3.506944 -2.894990
4 Log Transformation Customer Service Representative -6.332940 2.876519e-08 -3.515977 -2.898886
5 Log Transformation Accountant -5.950297 2.155174e-07 -3.519481 -2.900395
6 Log Transformation Sales Operations Manager -6.215294 5.384224e-08 -3.530399 -2.905087
7 Log Transformation Management counsultant -5.721408 6.927615e-07 -3.530399 -2.905087
8 Log Transformation Web Developer -5.096311 1.426044e-05 -3.531955 -2.905755
9 Log Transformation Sales Director -5.902054 2.763263e-07 -3.550670 -2.913766
10 Log Transformation Teacher -2.737167 6.782462e-02 -3.562879 -2.918973
11 Log Transformation Skilled Workers -8.589371 7.357021e-14 -3.565624 -2.920142
12 Log Transformation Data Entry Operator -3.474673 8.661866e-03 -3.584829 -2.928299
13 Log Transformation Medical Representative -3.272182 1.616869e-02 -3.581258 -2.926785
14 Log Transformation Trainer -2.124539 2.347626e-01 -3.600983 -2.935135
15 Log Transformation Electrial Engineer -4.427601 2.651690e-04 -3.588573 -2.929886
16 Log Transformation Graphic Designer -5.583107 1.382222e-06 -3.588573 -2.929886
17 Log Transformation Data Modeler -6.510337 1.104471e-08 -3.596636 -2.933297
18 Log Transformation Civil Engineer -6.638242 5.492855e-09 -3.596636 -2.933297
19 Log Transformation Financial Analyst -4.886284 3.708290e-05 -3.596636 -2.933297
20 Log Transformation Content Writer -5.691809 8.039062e-07 -3.596636 -2.933297
21 Log Transformation Computer Network Specialist -4.964913 2.602918e-05 -3.596636 -2.933297
22 Log Transformation Actuary -7.146346 3.225321e-10 -3.600983 -2.935135
23 Log Transformation Investor Relation Associate -4.764090 6.367386e-05 -3.610400 -2.939109
24 Log Transformation HR Executive -5.685763 8.286640e-07 -3.610400 -2.939109

Top 3 Best Transformation For Forcasting

In [30]:
k=1
for i in job_pre.index:
    soj=stat[stat['Job']==i]
    print(str(k)+']  '+i.upper(),'\n')
    soj=soj[(soj['p-value']<= 0.05)&((soj['Critical Value (1%)']>soj['Test Statistic'])&(soj['Critical Value (5%)']>soj['Test Statistic']))]
    soj=soj.sort_values('p-value')
    sojl=soj['Transformation'][0:3].values
    j=1
    for i in sojl:
        print(str(j)+'. '+i)
        j+=1
    print("___________________________________________________________________________________________\n")
    k+=1
1]  SALES MANAGER 

1. Differencing Transformation (Shift 3)
2. Differencing Transformation (Shift 2)
3. Differencing Transformation (Shift 1)
___________________________________________________________________________________________

2]  SOFTWARE/APPLICATION DEVELOPER 

1. Quantile Transformation ( Normal )
2. Differencing Transformation (Shift 1)
3. Function Transformation
___________________________________________________________________________________________

3]  SALES DEVELOPMENT REPRESENTATIVE 

1. Differencing Transformation (Shift 3)
2. Differencing Transformation (Shift 2)
3. Differencing Transformation (Shift 1)
___________________________________________________________________________________________

4]  GENERAL AND OPERATIONS MANAGER 

1. Differencing Transformation (Shift 1)
2. Quantile Transformation ( Normal )
3. Quantile Transformation ( Uniform )
___________________________________________________________________________________________

5]  CUSTOMER SERVICE REPRESENTATIVE 

1. Differencing Transformation (Shift 3)
2. Differencing Transformation (Shift 1)
3. Log Transformation
___________________________________________________________________________________________

6]  ACCOUNTANT 

1. Differencing Transformation (Shift 1)
2. StandardScaler Transformation (Standardization)
3. MaxAbsScaler Transformation
___________________________________________________________________________________________

7]  SALES OPERATIONS MANAGER 

1. Differencing Transformation (Shift 3)
2. Differencing Transformation (Shift 1)
3. MaxAbsScaler Transformation
___________________________________________________________________________________________

8]  MANAGEMENT COUNSULTANT 

1. Differencing Transformation (Shift 2)
2. Differencing Transformation (Shift 1)
3. Quantile Transformation ( Normal )
___________________________________________________________________________________________

9]  WEB DEVELOPER 

1. Differencing Transformation (Shift 2)
2. Quantile Transformation ( Uniform )
3. Differencing Transformation (Shift 1)
___________________________________________________________________________________________

10]  SALES DIRECTOR 

1. Differencing Transformation (Shift 2)
2. Differencing Transformation (Shift 1)
3. MaxMinScaler Transfromation (Normalization)
___________________________________________________________________________________________

11]  TEACHER 

1. Differencing Transformation (Shift 3)
2. Differencing Transformation (Shift 2)
3. Differencing Transformation (Shift 1)
___________________________________________________________________________________________

12]  SKILLED WORKERS 

1. Quantile Transformation ( Normal )
2. Square Root Transformation
3. Cube Root Transformation
___________________________________________________________________________________________

13]  DATA ENTRY OPERATOR 

1. Differencing Transformation (Shift 2)
2. Differencing Transformation (Shift 1)
3. Differencing Transformation (Shift 3)
___________________________________________________________________________________________

14]  MEDICAL REPRESENTATIVE 

1. Differencing Transformation (Shift 1)
2. Differencing Transformation (Shift 2)
___________________________________________________________________________________________

15]  TRAINER 

1. Differencing Transformation (Shift 1)
2. Differencing Transformation (Shift 2)
3. Differencing Transformation (Shift 3)
___________________________________________________________________________________________

16]  ELECTRIAL ENGINEER 

1. Differencing Transformation (Shift 1)
2. Quantile Transformation ( Uniform )
3. Quantile Transformation ( Normal )
___________________________________________________________________________________________

17]  GRAPHIC DESIGNER 

1. Log Transformation
2. Robust Scaler Transformation
3. MaxMinScaler Transfromation (Normalization)
___________________________________________________________________________________________

18]  DATA MODELER 

1. Differencing Transformation (Shift 3)
2. Quantile Transformation ( Normal )
3. Quantile Transformation ( Uniform )
___________________________________________________________________________________________

19]  CIVIL ENGINEER 

1. Power Transformation ( Yeo-Johnson )
2. Function Transformation
3. Quantile Transformation ( Uniform )
___________________________________________________________________________________________

20]  FINANCIAL ANALYST 

1. Differencing Transformation (Shift 1)
2. MaxAbsScaler Transformation
3. Log Transformation
___________________________________________________________________________________________

21]  CONTENT WRITER 

1. Differencing Transformation (Shift 2)
2. Power Transformation ( Box-Cox )
3. Power Transformation ( Yeo-Johnson )
___________________________________________________________________________________________

22]  COMPUTER NETWORK SPECIALIST 

1. Differencing Transformation (Shift 1)
2. Quantile Transformation ( Uniform )
3. Power Transformation ( Box-Cox )
___________________________________________________________________________________________

23]  ACTUARY 

1. Differencing Transformation (Shift 1)
2. Function Transformation
3. Cube Root Transformation
___________________________________________________________________________________________

24]  INVESTOR RELATION ASSOCIATE 

1. Differencing Transformation (Shift 2)
2. Differencing Transformation (Shift 3)
3. Differencing Transformation (Shift 1)
___________________________________________________________________________________________

25]  HR EXECUTIVE 

1. Differencing Transformation (Shift 1)
2. Log Transformation
3. MaxMinScaler Transfromation (Normalization)
___________________________________________________________________________________________

26]  SALES ASSOCIATE 

1. Differencing Transformation (Shift 1)
2. Differencing Transformation (Shift 2)
3. MaxMinScaler Transfromation (Normalization)
___________________________________________________________________________________________

27]  COMPUTER SUPPORT SPECIALIST 

1. Differencing Transformation (Shift 1)
2. Quantile Transformation ( Uniform )
3. Power Transformation ( Box-Cox )
___________________________________________________________________________________________

28]  COMPUTER OPERATOR 

1. Differencing Transformation (Shift 3)
2. Differencing Transformation (Shift 1)
3. Differencing Transformation (Shift 2)
___________________________________________________________________________________________

29]  IT INDUSTRY SALES 

1. Differencing Transformation (Shift 3)
2. Function Transformation
3. Cube Root Transformation
___________________________________________________________________________________________

30]  RECEPTIONIST 

___________________________________________________________________________________________

MODEL ARIMA

In [35]:
p=d=q=range(0,5)
pdq=list(itertools.product(p,d,q))
aic_rsme=pd.DataFrame(columns=['Transformation','Job','AIC','RSME','p','d','q'])

def arima_model(ts,Transformation,job): 
    aic=[]
    for param in pdq:   
        try:
            demand_model=ARIMA(ts,order=param)
            demand_model_fit=demand_model.fit()
            #print(param,"AIC = "+str(demand_model_fit.aic))
            par=[param,demand_model_fit.aic]
            aic.append(par)
        except:
            continue

    aic_df=pd.DataFrame(aic)
    aic_df=aic_df.set_index(aic_df[0])
    aic_df=aic_df[1]
    aic_sort=aic_df.sort_values(ascending=True)
    best_aic=aic_sort.index[0]
    #print("Best values of p, d & q for ARIMA model are p = %d, d = %d & q = %d"%(best_aic[0],best_aic[1],best_aic[2]))
    #print("AIC =",aic_sort[0])
    #print("____________________________________________________________________")
    
    t=len(ts)-25
    demand_train=ts[0:t]
    demand_test=ts[t:]
    demand_forecast=demand_model_fit.forecast(steps=25)[0]
    jobs_error=mean_squared_error(demand_test,demand_forecast)
    #print("RSME = ",np.sqrt(jobs_error))
    #print("_____________________________________________________________________")
    global aic_rsme
    trans_aic_rsme=pd.DataFrame({"Transformation":[Transformation],"Job":[job],"AIC":aic_sort[0],"RSME":np.sqrt(jobs_error),"p":best_aic[0],"d":best_aic[1],"q":best_aic[2]}, index=[0])
    aic_rsme=aic_rsme.append(trans_aic_rsme,ignore_index=True)
    print(i.upper())

1. Log Transformation

In [36]:
print("Completed")
print("________________________________________\n")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    demand_log=np.log(d_it)
    arima_model(d_it,'Log Transformation',i)
print("\n________________________________________")    
Completed
________________________________________

SALES MANAGER
SOFTWARE/APPLICATION DEVELOPER
SALES DEVELOPMENT REPRESENTATIVE
GENERAL AND OPERATIONS MANAGER
CUSTOMER SERVICE REPRESENTATIVE
ACCOUNTANT
SALES OPERATIONS MANAGER
MANAGEMENT COUNSULTANT
WEB DEVELOPER
SALES DIRECTOR
TEACHER
SKILLED WORKERS
DATA ENTRY OPERATOR
MEDICAL REPRESENTATIVE
TRAINER
ELECTRIAL ENGINEER
GRAPHIC DESIGNER
DATA MODELER
CIVIL ENGINEER
FINANCIAL ANALYST
CONTENT WRITER
COMPUTER NETWORK SPECIALIST
ACTUARY
INVESTOR RELATION ASSOCIATE
HR EXECUTIVE
SALES ASSOCIATE
COMPUTER SUPPORT SPECIALIST
COMPUTER OPERATOR
IT INDUSTRY SALES
RECEPTIONIST

________________________________________

2. MaxMinScaler Transfromation (Normalization)

In [37]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    #print(i)
    demand_values=d_it.values
    scaler=MinMaxScaler(feature_range=(0,1))
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_nor=demand_nor.flatten()
    demand_nor=pd.Series(demand_nor,index=index)
    arima_model(demand_nor,'MaxMinScaler Transfromation (Normalization)',i)
print("________________________________________")  
Completed
________________________________________
SALES MANAGER
SOFTWARE/APPLICATION DEVELOPER
SALES DEVELOPMENT REPRESENTATIVE
GENERAL AND OPERATIONS MANAGER
CUSTOMER SERVICE REPRESENTATIVE
ACCOUNTANT
SALES OPERATIONS MANAGER
MANAGEMENT COUNSULTANT
WEB DEVELOPER
SALES DIRECTOR
TEACHER
SKILLED WORKERS
DATA ENTRY OPERATOR
MEDICAL REPRESENTATIVE
TRAINER
ELECTRIAL ENGINEER
GRAPHIC DESIGNER
DATA MODELER
CIVIL ENGINEER
FINANCIAL ANALYST
CONTENT WRITER
COMPUTER NETWORK SPECIALIST
ACTUARY
INVESTOR RELATION ASSOCIATE
HR EXECUTIVE
SALES ASSOCIATE
COMPUTER SUPPORT SPECIALIST
COMPUTER OPERATOR
IT INDUSTRY SALES
RECEPTIONIST
________________________________________

3. StandardScaler Transformation (Standardization)

In [38]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    
    demand_values=d_it.values
    demand_values=demand_values.reshape(len(demand_values),1)
    std_scaler=StandardScaler()
    std_scaler_fit=std_scaler.fit(demand_values)
    demand_std=std_scaler.transform(demand_values)
    index=d_it.index
    demand_std=demand_std.flatten()
    demand_std=pd.Series(demand_std,index=index)
    arima_model(demand_std,'StandardScaler Transformation (Standardization)',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

4. Square Root Transformation

In [39]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_sqrt=np.sqrt(d_it)
    arima_model(demand_sqrt,'Square Root Transformation',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

5. Cube Root Transformation

In [40]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_cbrt=np.cbrt(d_it)
    arima_model(demand_cbrt,'Cube Root Transformation',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

6. Differencing Transformation (Shift 1)

In [41]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_diff=d_it.diff(periods=1)
    demand_diff.dropna(inplace=True)
    arima_model(demand_diff,'Differencing Transformation (Shift 1)',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

7. Differencing Transformation (Shift 2)

In [42]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_diff2=d_it.diff(periods=2)
    demand_diff2.dropna(inplace=True)
    arima_model(demand_diff2,'Differencing Transformation (Shift 2)',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

8. Differencing Transformation (Shift 3)

In [43]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_diff3=d_it.diff(periods=3)
    demand_diff3.dropna(inplace=True)
    arima_model(demand_diff3,'Differencing Transformation (Shift 3)',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

9. Power Transformation ( Box-Cox )

In [44]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values   
    scaler=PowerTransformer(method='box-cox')
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_pow_bc=demand_nor.flatten()
    demand_pow_bc=pd.Series(demand_pow_bc,index=index)
    arima_model(demand_pow_bc,'Power Transformation ( Box-Cox )',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

10. Power Transformation ( Yeo-Johnson )

In [45]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values   
    scaler=PowerTransformer(method='yeo-johnson')
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_pow_yj=demand_nor.flatten()
    demand_pow_yj=pd.Series(demand_pow_yj,index=index)
    arima_model(demand_pow_yj,'Power Transformation ( Yeo-Johnson )',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

11. MaxAbsScaler Transformation

In [46]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=MaxAbsScaler()
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_abs=demand_nor.flatten()
    demand_abs=pd.Series(demand_abs,index=index)
    arima_model(demand_abs,'MaxAbsScaler Transformation',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

12. Robust Scaler Transformation

In [47]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=RobustScaler()
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_rs=demand_nor.flatten()
    demand_rs=pd.Series(demand_rs,index=index)
    arima_model(demand_rs,'Robust Scaler Transformation',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

13. Quantile Transformation ( Uniform )

In [48]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=QuantileTransformer(output_distribution='uniform')
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_qtu=demand_nor.flatten()
    demand_qtu=pd.Series(demand_qtu,index=index)
    arima_model(demand_qtu,'Quantile Transformation ( Uniform )',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

14. Quantile Transformation ( Normal )

In [49]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=QuantileTransformer(output_distribution='normal')
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_qtn=demand_nor.flatten()
    demand_qtn=pd.Series(demand_qtn,index=index)
    arima_model(demand_qtn,'Quantile Transformation ( Normal )',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

15. Function Transformation

In [50]:
print("Completed")
print("________________________________________")  
for i in job_pre.index:
    it=df1[df1['Job']==i]
    d_it=it.groupby('Posted_Date')['Posted_Date'].count()
    print(i)
    demand_values=d_it.values
    scaler=FunctionTransformer(np.log1p)
    demand_values=demand_values.reshape(len(demand_values),1)
    scaler_fit=scaler.fit(demand_values)
    demand_nor=scaler.transform(demand_values)
    index=d_it.index
    #demand_nor=demand_nor.reshape(len(demand_values),1)
    demand_ft=demand_nor.flatten()
    demand_ft=pd.Series(demand_ft,index=index)
    arima_model(demand_ft,'Function Transformation',i)
print('________________________________________')
Completed
________________________________________
Sales Manager
SALES MANAGER
Software/Application Developer
SOFTWARE/APPLICATION DEVELOPER
Sales Development Representative
SALES DEVELOPMENT REPRESENTATIVE
General and Operations manager
GENERAL AND OPERATIONS MANAGER
Customer Service Representative
CUSTOMER SERVICE REPRESENTATIVE
Accountant
ACCOUNTANT
Sales Operations Manager
SALES OPERATIONS MANAGER
Management counsultant
MANAGEMENT COUNSULTANT
Web Developer
WEB DEVELOPER
Sales Director
SALES DIRECTOR
Teacher
TEACHER
Skilled Workers
SKILLED WORKERS
Data Entry Operator
DATA ENTRY OPERATOR
Medical Representative
MEDICAL REPRESENTATIVE
Trainer
TRAINER
Electrial Engineer
ELECTRIAL ENGINEER
Graphic Designer
GRAPHIC DESIGNER
Data Modeler
DATA MODELER
Civil Engineer
CIVIL ENGINEER
Financial Analyst
FINANCIAL ANALYST
Content Writer
CONTENT WRITER
Computer Network Specialist
COMPUTER NETWORK SPECIALIST
Actuary
ACTUARY
Investor Relation Associate
INVESTOR RELATION ASSOCIATE
HR Executive
HR EXECUTIVE
Sales Associate
SALES ASSOCIATE
Computer Support Specialist
COMPUTER SUPPORT SPECIALIST
Computer Operator
COMPUTER OPERATOR
IT Industry Sales
IT INDUSTRY SALES
Receptionist
RECEPTIONIST
________________________________________

Dataframe consisting of AIC and RSME value of each transformation

In [51]:
aic_rsme
Out[51]:
Transformation Job AIC RSME p d q
0 Log Transformation Sales Manager 631.002969 7.697243 1 1 1
1 Log Transformation Software/Application Developer 618.345988 4.796173 1 1 1
2 Log Transformation Sales Development Representative 429.600438 3.557432 0 2 2
3 Log Transformation General and Operations manager 513.753285 6.808059 1 0 0
4 Log Transformation Customer Service Representative 338.977348 1.876698 1 0 1
... ... ... ... ... ... ... ...
445 Function Transformation Sales Associate -8.140309 0.661439 4 0 1
446 Function Transformation Computer Support Specialist 26.942611 0.758022 2 0 1
447 Function Transformation Computer Operator -4.135804 0.603047 0 0 0
448 Function Transformation IT Industry Sales 9.230767 1.117224 0 0 1
449 Function Transformation Receptionist 6.319515 0.756712 3 1 3

450 rows × 7 columns

In [52]:
aic_rsme.to_excel('AIC_RSME.xlsx', engine="xlsxwriter")